View Full Version : answers

Pages : 1 2 3 4 5 6 7 8 9 10 11 12 [13] 14 15 16 17 18 19 20
  1. 98{ working for someone else sucks!
  2. Running MySQL Database Engine from CD
  3. basic question - getting started with mysql
  4. Simple Case Statement Help
  5. Decimal vs Integer
  6. looking for parameters for SQLDriverConnect
  7. Indexes with OR queries
  8. Mysql 4.1.0 Nested Sql Statements
  9. LIKE operator and percent mark (%) syntax in comparison queries
  10. Group Query and want to include null values
  11. copy data from one table to another
  12. MySQL database on an NFS share
  13. Both full text and normal index to the same field
  14. GROUP BY and ORDER BY
  15. Please I need help with REPLICATION! :(
  16. embedded MySQL server via myODBC ?
  17. ERROR 1062: Duplicate entry for key 2
  18. authentication problem on nonstandard port
  19. Replication
  20. UDF in Create Index
  21. MySql 4.1.1 Password problem - client can't connect
  22. How do I make mysql hang
  23. troubles remeving records
  24. Help me with REGEXP please !
  25. SQL Humour
  26. troubles remeving records
  27. Order by before group by
  28. UNIQUE ?
  29. "not unique table/alias"
  30. Whats hte problem with this query???
  31. MSN E-mail Status: Delayed
  32. MSN Groups Welcome Message
  33. Order of the columns (timestamp) in create statement makes a difference
  34. MySQL and RELATIONSHIPS
  35. MS SQL Hostname Changeq
  36. Hostname change and SQL
  37. It's my birthday... Please help me!
  38. Earle
  39. select query optimization for 3 choices
  40. MySQL and Linux - dababase connection problem
  41. LAMP developers on Yahoo
  42. Tab delimited text file into mysql
  43. JDBC driver licensing and distribution
  44. MySql 4.1.1 Password problem - client can't connect
  45. Best way to move data between Internet and local server?
  46. OS Comamnds
  47. Virtuel-Counting-Row
  48. Primary Key Offset
  49. how to store the password in the ENCRYPT form using castor jdo
  50. 98] Fill out questionnaires and be paid!
  51. How many database does MySQL Support?
  52. How to execute a script in MySQL?
  53. How to execute a script in MySQL?
  54. webmail mysql table question
  55. webmail mysql table question
  56. Problems with mysql service after innodb tablespace > 500GB
  57. Bad handshake from 4.1.0 to 4.1.1
  58. manipulating ORDER BY
  59. ADODB.Recordset.1 error '80004005'
  60. many databases with 1 table or 1 database with many tables
  61. Problem with CONCAT function (bug?)
  62. Problem with CONCAT function (bug?)
  63. mysql_pconnect() vs mysql_connect()
  64. mysql_pconnect() vs mysql_connect()
  65. Upper/Lower Case trouble in query statement
  66. Accessing DBMS remotely: MySQL? FireBird?
  67. Visual Studio .Net DataProviders for mySQL
  68. subquery bug or compilation prob?
  69. production 5.0 release when?
  70. network connections
  71. help with Selecting Post Codes
  72. CA-Clipper to mysql help??
  73. CA-Clipper to mysql help??
  74. need help for my honours project
  75. MAX CONNECTIONS
  76. Create the effective index
  77. Create the effective index
  78. MySQL query question...
  79. Build Mysql 4.0.18 on Aix 5.2
  80. Having problems with subqueries
  81. Peformance
  82. Strange Problem... [Help!]
  83. Strange Problem... [Help!]
  84. SQL Socket Error
  85. SQL Socket Error
  86. mysql backup trouble
  87. mysql backup trouble
  88. Problem with SELECT Statement
  89. Problem with SELECT Statement
  90. Joining parent with child table, only want one row of child (mySQL database)
  91. C-JDBC capabilities
  92. Visual Studio Server Explorer problem
  93. MySQL compare a timestamp with offset and the current date
  94. Visual Studio Server Explorer problem
  95. User access
  96. mysql + odbc
  97. revoke rights for one user & table
  98. ReInstall MySQL? Help!
  99. Apache2triad 1.2 - innoDB tables
  100. Managing content
  101. Row Comment?
  102. MySQL Error with select statement in procedure
  103. Select/Update/Delete by Primary key failing with InnoDB
  104. DELETE question
  105. Problem With Select Statement ~ Can anyone Help?
  106. How To: RETRIEVE FIELD NAMES from a TABLE???
  107. How To: RETRIEVE FIELD NAMES from a TABLE???
  108. Adding records via libmySQL.dll
  109. how to insert a quote char
  110. Mysql
  111. buy & sell clothing
  112. delimiter |
  113. find all products with maximum version
  114. Problematic IF statements
  115. Complex sorting and merging
  116. Best practice: different db for different users OR user ID in same db?
  117. Scalability/overload
  118. Why do these two queries exhibit such different behavior?
  119. Why do these two queries exhibit such different behavior?
  120. access to mysql
  121. access to mysql
  122. problem to connect to mysql...
  123. problem to connect to mysql...
  124. Why using TCP/IP instead of Unix Sockets?
  125. Error Message
  126. Error Message
  127. Connection problems
  128. Calculated field?
  129. Connection problems
  130. How to get existence of ads by publisher in same query
  131. Combining multiple records into one based on a key field -- inside one table !
  132. Combining multiple records into one based on a key field -- inside one table !
  133. Merging databases
  134. Problem Retrieving Unicode Data
  135. Problem Retrieving Unicode Data
  136. One large table or many small tables?
  137. MySQL 'IN' Operator Syntax
  138. Retrieve MySQL data
  139. Retrieve MySQL data
  140. Do update with IF condition... in MySQL
  141. Script Help Required
  142. storing samples of data in mysql
  143. bought
  144. mysqlclient libraries missing in binary version 4 for Aix 5.2
  145. ado connection string for tcpip port
  146. ODBC Connection keeps dropping off...
  147. New and need help with form
  148. pattern matching
  149. Default Peramaters
  150. SQLServer 2000 Conversion
  151. auto_increment reuse in MyISAM
  152. SQLServer 2000 Conversion
  153. limit space in the user account
  154. auto_increment reuse in MyISAM
  155. make this table
  156. get IGF, make your member bigger
  157. My notes: Hopefully this will help someone
  158. My notes: Hopefully this will help someone
  159. one SET vs. many BIT (TINYINT)? pros/cons?
  160. Easy join with equal, star-equal, equal star (like MSSQL)
  161. rationales ckum like a pkorn star
  162. low performance with linux SMP
  163. insert into different table
  164. ORDER BY
  165. log
  166. Accessing MySQL from VB6
  167. refreshing my.cnf
  168. Could someone explain this to me?
  169. MySQL and Winsock
  170. select + update statement
  171. error with mysql setup
  172. Join on multiple fields and tables
  173. loading data
  174. Switching indexing types?
  175. text files
  176. Create View Statements
  177. UPS WorldShip
  178. Do you want a prosperous future? GET YOUR UNIVERSITY DIPLOMA!
  179. Do you want a prosperous future? GET YOUR UNIVERSITY DIPLOMA!
  180. mysql database symlink
  181. Mysql general info about product
  182. Mysql general info about product
  183. MYSQL + Win32 = Difficulties
  184. MYSQL + Win32 = Difficulties
  185. dumb syntax question
  186. phpmyadmin export problem with order of table creation
  187. dumb syntax question
  188. Who is taking all of my connections?
  189. Who is taking all of my connections?
  190. JOIN query works with 3.23 but not 4.0.13
  191. phpmyadmin export problem with order of table creation
  192. Optimizing a simple UNION query
  193. record number
  194. JOIN query works with 3.23 but not 4.0.13
  195. Optimizing a simple UNION query
  196. record number
  197. Connecting
  198. Connecting
  199. Timezone test fails with 4.0.18 on linux?
  200. fatal: libz.so: open failed: No such file or directory
  201. Timezone test fails with 4.0.18 on linux?
  202. replication error
  203. fatal: libz.so: open failed: No such file or directory
  204. How to make a "group by ordered" ?
  205. file system driver for mysql
  206. replication error
  207. How to make a "group by ordered" ?
  208. importing problem
  209. file system driver for mysql
  210. Date Calculation query.
  211. importing problem
  212. importing problem
  213. Date Calculation query.
  214. A LEFT JOIN with LIKE? Can that be done?
  215. updating record(s) but substituting value into field
  216. Swap usage on RH 9
  217. alternatives to fulltext?
  218. MySQL not working after reboot
  219. A LEFT JOIN with LIKE? Can that be done?
  220. Selecting values and their corresponding percentages
  221. updating record(s) but substituting value into field
  222. Using group by date and count
  223. alternatives to fulltext?
  224. Swap usage on RH 9
  225. Problem using MySQLDriverCS
  226. MySQL not working after reboot
  227. Selecting values and their corresponding percentages
  228. Using group by date and count
  229. computations when doing a join
  230. Problem using MySQLDriverCS
  231. select and produce row from empty table
  232. Error accessing MS Access table linked to MySQL
  233. Non matching records
  234. computations when doing a join
  235. Solution for installing MySQL on Mac OS X....
  236. VIEW in MySQL
  237. VIEW in MySQL
  238. Comparings tables and outputing the diff.
  239. Error accessing MS Access table linked to MySQL
  240. select and produce row from empty table
  241. Recover database without .frm file ?
  242. Multiple join query question
  243. Non matching records
  244. Solution for installing MySQL on Mac OS X....
  245. mysql_real_connect problem!
  246. VIEW in MySQL
  247. Wrong path in Component Services
  248. VIEW in MySQL
  249. Comparings tables and outputing the diff.
  250. REQ: Help with M:N cross referenced tables requested
  251. mysqldump Backup To More Than One File
  252. MySQL++ for Visual Studio 2003?
  253. Recover database without .frm file ?
  254. Multiple join query question
  255. Help with Complex joins
  256. using a constant field
  257. No connection Error
  258. mysql_real_connect problem!
  259. Wrong path in Component Services
  260. Indexing process
  261. REQ: Help with M:N cross referenced tables requested
  262. mysqldump Backup To More Than One File
  263. MySQL++ for Visual Studio 2003?
  264. obtaining the field
  265. Query question using variables
  266. Help with Complex joins
  267. using a constant field
  268. Help with Complex joins
  269. using a constant field
  270. Indexing process
  271. No connection Error
  272. Is MySQL what I need?
  273. mysql 4 for win2k
  274. How to copy a database
  275. obtaining the field
  276. convert int field to a string
  277. query JOIN question (2 JOINs ?)
  278. Query question using variables
  279. Is MySQL what I need?
  280. mysql 4 for win2k
  281. How to copy a database
  282. convert int field to a string
  283. query JOIN question (2 JOINs ?)
  284. UPDATE step thru every record w/out unique id field
  285. UPDATE step thru every record w/out unique id field
  286. Cant't connect
  287. LOAD DATA odd failure
  288. MySQL
  289. Cant't connect
  290. Complex query - need help (where a OR b, SUM() etc)
  291. HELP ME PLEASE.
  292. LOAD DATA odd failure
  293. tcp/ip instead of sockets
  294. MySQL
  295. Creating a query based on dates
  296. Complex query - need help (where a OR b, SUM() etc)
  297. MS Access ODBC sees data but can't display it
  298. HELP ME PLEASE.
  299. tcp/ip instead of sockets
  300. run mysql using tcp/ip instead of sockets?
  301. tcp/ip instead of sockets
  302. No errors just help needed ( mysql help )
  303. MS Access ODBC sees data but can't display it
  304. feel you got ripped off in university? What? no diploma?
  305. Creating a query based on dates
  306. MS Access ODBC sees data but can't display it
  307. mysql extended server status variables
  308. Creating a query based on dates
  309. No errors just help needed ( mysql help )
  310. No errors just help needed ( mysql help )
  311. run mysql using tcp/ip instead of sockets?
  312. feel you got ripped off in university? What? no diploma?
  313. run mysql using tcp/ip instead of sockets?
  314. howto insert into the middle of a table
  315. feel you got ripped off in university? What? no diploma?
  316. mysql extended server status variables
  317. mysql extended server status variables
  318. Unnacceptable waitingtime for a left join query. What's wrong?
  319. Source for SQL or CSV Auto Make/Model data?
  320. howto insert into the middle of a table
  321. Database optimization width MySQL ?
  322. Source for SQL or CSV Auto Make/Model data?
  323. Unnacceptable waitingtime for a left join query. What's wrong?
  324. howto insert into the middle of a table
  325. Flash version of phpMyAdmin
  326. Source for SQL or CSV Auto Make/Model data?
  327. Database optimization width MySQL ?
  328. Unnacceptable waitingtime for a left join query. What's wrong?
  329. Flash version of phpMyAdmin
  330. Database optimization width MySQL ?
  331. Flash version of phpMyAdmin
  332. Windows -> Linux problem
  333. MyODBC recognize all BLOB fields as FIELD_TYPE_BLOB?
  334. PHP/mySQL connect
  335. Mysql-python installation problems....
  336. Perplexing problem
  337. [unixODBC][Driver Manager]Can't open cursor lib 'libodbccr'
  338. Query with 1 converted t Yes and 0 converted to No
  339. error 1045
  340. old Mysql query problem
  341. Variables in MySQL
  342. Variables in MySQL
  343. Triggers in MaxDB 7.5*
  344. Slow queries
  345. default MYSQL server password
  346. MYSQL SSH FORWARDING ERROR 2013
  347. mysqldump
  348. Relationship between 2 tables?
  349. How to store jpg in mySQL?
  350. Cold Fusion & mySQL ?
  351. Help With a Query!! (Please...)
  352. UPDATE query causes CPU drain
  353. Displaying Time values from a linked MySQL table in MS Access
  354. ERR: Data (not Date) From SQL Server to mySQL
  355. Date From SQL Server to MySQL
  356. How can I give a user dba privileges?
  357. Subqueries not working
  358. php mysql select substring
  359. php mysql select substring
  360. logging into server
  361. simple Front End for MySQL
  362. SELECT and DECODE using LIKE??
  363. Query not appearing to use an index
  364. SELECT and DECODE using LIKE??
  365. Query not appearing to use an index
  366. start sharing your opinion today and you will be rewarded!
  367. Replication - 4.0.16
  368. start sharing your opinion today and you will be rewarded!
  369. How does one add or subtract two fields in a select statement
  370. utilisation de mysql
  371. OneClickRevelation: JDX Provides Instant and Interactive Insight Into Your Data
  372. OneClickRevelation: JDX Provides Instant and Interactive Insight Into Your Data
  373. Getting values from row with the largets id
  374. MySQL taking too long
  375. Getting values from row with the largets id
  376. MySQL taking too long
  377. whats wrong with this syntax
  378. Relationship for table
  379. whats wrong with this syntax
  380. Relationship for table
  381. The 2004 edition of The American Medical Directory doctors, physicians, zwtf dxg
  382. read out an AUTO_INCREMENT-ed value
  383. The 2004 edition of The American Medical Directory doctors, physicians, zwtf dxg
  384. How do I SELECT FROM columns where the COLUMNS has a PATTERN?
  385. ON UPDATE CASCADE, is it correct that b remains NULL? even after update?
  386. ON UPDATE CASCADE, is it correct that b remains NULL? even after update?
  387. comparing versions of sql
  388. comparing versions of sql
  389. Select all records less than 10 minutes old?
  390. Select all records less than 10 minutes old?
  391. need simple join help
  392. need simple join help
  393. converting "dd-mm-yyyy" to "yyyy-mm-dd"
  394. InnoDB autodeletion ONLY when ALL Parent rows with ID=x are deleted, possible???
  395. UDF with Update
  396. InnoDB autodeletion ONLY when ALL Parent rows with ID=x are deleted, possible???
  397. UDF with Update
  398. Can't execute LOCK TABLES statement from mysql++?
  399. How to clear error state from connection?
  400. images of performance charts?
  401. How to find out if a msql table is locked from a php script
  402. Making mysql_connect more efficient in my script
  403. images of performance charts?
  404. MySQL security
  405. INSERT SQL for common fields
  406. Making mysql_connect more efficient in my script
  407. INSERT SQL for common fields
  408. Converting Filemaker Solutions to MySQL
  409. Compress protocol and SSL
  410. Converting Filemaker Solutions to MySQL
  411. DELETE Query with left join?
  412. Compress protocol and SSL
  413. Internal generated Foreign Key ID
  414. How to access Mysql server (LINUX) from mysql control center (WINDOWS)
  415. How to access Mysql server (LINUX) from mysql control center (WINDOWS)
  416. LEFT JOIN out of whack
  417. LEFT JOIN out of whack
  418. How to set default values for timestamp fields
  419. How to set default values for timestamp fields
  420. primary key not enforced..?
  421. selecting in reverse order
  422. Export from Oracle 8.1.7,9i or MS SQL Server to MySQL
  423. SQL subquery problem - bookings database
  424. 2 OSes, 1 DB
  425. Connection/Client crash
  426. MySQL rpm upgrade problems
  427. Connection/Client crash
  428. REPLY SOON
  429. Upgrade to 4.1.1 from 4.0 and keep getting corrupted table
  430. It's time to invest in good quality growth stocks cw
  431. Weighted Full Text Search Question
  432. Compiling options
  433. MFC and MySQL API VC++ 6
  434. Views support in 5.0.0-alpha
  435. how to get Mysql table list ? (sysobject like)
  436. Double entry
  437. mysql password() & unix crypt password...
  438. How to delete related records??
  439. escaping before inserts - get_magic_quotes_gpc
  440. escaping before inserts - get_magic_quotes_gpc
  441. How I can save both japanese and english characters, in my text box?
  442. How I can save both japanese and english characters, in my text box?
  443. MySQL 4.0.15 vs. Oracle query ARRGH
  444. Command Line Parameters for MyODBC 3.51 Windows Installer
  445. MySQL 4.0.15 vs. Oracle query ARRGH
  446. MySQL Government Licencing
  447. Command Line Parameters for MyODBC 3.51 Windows Installer
  448. SQL-Update-Statement
  449. SQL-Update-Statement
  450. Please help!! Sub Select Problem with MySQL 4.1
  451. MySQL Government Licencing
  452. Please help!! Sub Select Problem with MySQL 4.1
  453. Seeking help...
  454. Seeking help...
  455. Command line Database creation?
  456. Memory fault (core dumped)
  457. creating foreign key..
  458. Getting started...
  459. Getting started...
  460. multiple inserts and deletes
  461. query syntax
  462. BLOB column
  463. Trouble resolving mysql_prepare symbol
  464. Install MySQL 4.1 on Windows
  465. requiring where clause
  466. One Host but two masters
  467. Replication and InnoDB
  468. open files fill up partition
  469. Query
  470. creating database from batch file
  471. Tree structure
  472. What is the best way to store XML file in MySQL?
  473. How to store an array in the MySQL?
  474. problem connecting to localhost
  475. How to represent a date in C
  476. Connector/J not working with MySQL5.0?
  477. Selecting item from previous row
  478. IF Then in a Where clause
  479. IF Then in a Where clause
  480. "Unclosed Quote" Problem with phpMyAdmin
  481. Maximum Number of Fields allowed in MySQL Row?
  482. Maximum Number of Fields allowed in MySQL Row?
  483. Urgent Response
  484. Urgent Response
  485. Looking for good web based administration tool
  486. PHP and Mysql-Security Mailinglist ?
  487. Need help with optimizing / speeding up large MySQL MyISAM tables
  488. Need help with optimizing / speeding up large MySQL MyISAM tables
  489. About SQLState ...
  490. cannot change default-character-set in Mac OS X
  491. About SQLState ...
  492. MySQL character set and character length
  493. won't work with RB
  494. Seperate or Combined, the speed consideration
  495. Seperate or Combined, the speed consideration
  496. querying from different machines
  497. cannot connect to mySQL database using an applet
  498. Roles, stored procedures, user-defined functions
  499. MySQL Reporting Tool
  500. Import a text file (character set utf8) into a mysql db
  501. Slow response from MySQL
  502. Slow response from MySQL
  503. Sample databases for practicing
  504. Sample databases for practicing
  505. 4.1 timeline
  506. Help needed : Problems with WinMySqlAdmin
  507. Help needed : Problems with WinMySqlAdmin
  508. importing a complete database
  509. Car Models & Makes database
  510. Car Models & Makes database
  511. save picture files (.jpg) in database records or save only links to (.jpg)
  512. close mysql port or bind it to only localhost or ...
  513. How can I update a set of records in one single query PLEASE HELP
  514. How can I update a set of records in one single query PLEASE HELP
  515. Help! Select count from a list of digits ??
  516. Help! Select count from a list of digits ??
  517. Simple DB Design Questions
  518. Simple DB Design Questions
  519. Mysql count(*) problem
  520. Mysql count(*) problem
  521. Connecting to MYSQL from VC++ 6
  522. Selecting first occurance in a given period of record
  523. Connecting to MYSQL from VC++ 6
  524. Selecting first occurance in a given period of record
  525. Improving innodb performance
  526. SQL Query Problem on Dynamic PHP Page (HELP!)
  527. Improving innodb performance
  528. SQL Query Problem on Dynamic PHP Page (HELP!)
  529. Searching Multiple tables
  530. Searching Multiple tables
  531. mysql web host
  532. mysql metadata from asp
  533. Recovery data from Delete Query and Multi table deletion in MySQL
  534. Restart mySQL service after root password change
  535. Recovery data from Delete Query and Multi table deletion in MySQL
  536. Compacting MYSQL
  537. I need a easy graphical backup utility for mysql
  538. What's Wrong Here?
  539. trying a delete with subquery
  540. using database contents as column names
  541. Need guidance on and SQL problem
  542. Partitioning data - possible in mySQL?
  543. Need guidance on an SQL problem.
  544. ARM board in 2004
  545. Table is Full error and data loss after fix
  546. increment duplicate sting key
  547. Innodb: lockup problem caused machine slave to crash
  548. Check if field already exist
  549. Script to export all tables from a database (php)
  550. lylix