View Full Version : mysql answers


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 [15] 16 17 18 19 20 21

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