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. anyone know how to remove a character in one column..?
  2. MYSQL installation problem
  3. anyone know how to remove a character in one column..?
  4. MYSQL installation problem
  5. Books/Whitepapers ...
  6. mysql Equivalent of Transaction count of SQL Server
  7. Normalizing a table with less than 500 rows
  8. Books/Whitepapers ...
  9. Search with relavence using MATCH AGAINST
  10. mysql Equivalent of Transaction count of SQL Server
  11. optimize problem
  12. Normalizing a table with less than 500 rows
  13. Search with relavence using MATCH AGAINST
  14. optimize problem
  15. Using filesort
  16. using MyISAM directly
  17. Using filesort
  18. using MyISAM directly
  19. more than one condition in a HAVING clause
  20. Help for DB creation.
  21. more than one condition in a HAVING clause
  22. saturn
  23. saturn
  24. mysql 4 not stable enough??
  25. Help for DB creation.
  26. Most recent entries, different order
  27. Excel 2 CSV into phpMyAdmin
  28. mysql 4 not stable enough??
  29. Most recent entries, different order
  30. Excel 2 CSV into phpMyAdmin
  31. Why "service mysqld restart"??
  32. dear friend
  33. Why "service mysqld restart"??
  34. Problem building MySQL on SPARC Solaris 9
  35. Simple SQL Query syntax question HELP!
  36. straight_join, join order & join conditions
  37. dear friend
  38. Problem building MySQL on SPARC Solaris 9
  39. PLEASE I NEED YOUR ASSISTANCE
  40. Simple SQL Query syntax question HELP!
  41. straight_join, join order & join conditions
  42. PLEASE I NEED YOUR ASSISTANCE
  43. InnoDB, Can't create table
  44. Will simultaneous access defeat this strategy?
  45. InnoDB, Can't create table
  46. Odd/Even Autoincrements
  47. Will simultaneous access defeat this strategy?
  48. Odd/Even Autoincrements
  49. delete mysql and test database
  50. Problem joining select strings
  51. delete mysql and test database
  52. mysql dupe entry error, how to avoid?
  53. mysql dupe entry error, how to avoid?
  54. Problem joining select strings
  55. CHECKSUM
  56. mysql dupe entry error, how to avoid?
  57. mysql dupe entry error, how to avoid?
  58. CHECKSUM
  59. Assigning query results to a variable
  60. Assigning query results to a variable
  61. Newby question on creating an array
  62. SELECT probblem (how to)
  63. Newby question on creating an array
  64. SELECT probblem (how to)
  65. Graphical tool for constraint integrity
  66. No connect - error 111
  67. Graphical tool for constraint integrity
  68. No connect - error 111
  69. Problem installing MySQL Max rpm on RedHat 9
  70. Problem installing MySQL Max rpm on RedHat 9
  71. sub-query convert
  72. One last one mysqladmin
  73. sub-query convert
  74. One last one mysqladmin
  75. Newb starting MySql-Permissions
  76. Replication and mysqdump issue with database name
  77. Replication and mysqdump issue with database name
  78. Move data from one columnt to two others
  79. Move data from one columnt to two others
  80. Database was unreachable, had to kill over 10 processes, why?
  81. Database was unreachable, had to kill over 10 processes, why?
  82. MySQL and Relationships
  83. MySQL and Relationships
  84. Difference in SELECT WHERE IN with Datetime Fields
  85. MySQL RPM / Binary Q.
  86. Difference in SELECT WHERE IN with Datetime Fields
  87. Sorting on two fields?
  88. MySql Upgrade, 3.23.41 to 4.X questions.
  89. complex query
  90. MySQL Query across multiple
  91. Replicating data
  92. mysqld error on startup
  93. Multiple results in a quey
  94. Multiple results in a quey
  95. Algorithm of "select" statement
  96. Usinq MySQL and MS-SQL on the same machine?
  97. Usinq MySQL and MS-SQL on the same machine?
  98. which database?
  99. Problem with install database script?
  100. Problem with install database script?
  101. OMIM databse locally
  102. random connect/authenication error
  103. Help - Permission problem...?
  104. Help - Permission problem...?
  105. Simple fast way to grab the highest ID from a MySQL table?
  106. Simple fast way to grab the highest ID from a MySQL table?
  107. Loading pictures in mysql
  108. Selecting consecutive 'seats' in a seating chart
  109. Left Join query
  110. mysql shuts down during rapid execution of querys
  111. port number ???
  112. Enforcing NOT NULL restriction on UPDATE
  113. Enforcing NOT NULL restriction on UPDATE
  114. Using a Database for Logging: How to Design?
  115. Is it fundamental limitation of MySQL?
  116. problème installing viewCVS script
  117. my SQL Big Blob
  118. MySQL 4.0X
  119. MySQL 4.0X
  120. SQLJ and MySQL
  121. grouping by a day
  122. can I have MySQL on my PC ????
  123. Access2002/XP -> MySQL ???
  124. Access2002/XP -> MySQL ???
  125. Can't update DATETIME field using Visual Basic
  126. my.cnf memory specifications
  127. my.cnf memory specifications
  128. HotBackup for MyISAM tables?
  129. total newbe: some basic q
  130. Setting up mysql tables for UNICODE
  131. Updating single row in table causing all rows in table to be updated with same update.
  132. how do you create foreign key constraints in mySQL? Or Close to it?
  133. foreign key - on update cascade
  134. SQL from webpage:
  135. Mysql 4.1 meta.getColumns throws StringIndexOutOfBoundsException
  136. deamon stops immediately on RedHat 9
  137. Problem using curdate() with mysql ?
  138. Sub-Queries
  139. restricting records a user can update
  140. User questions...
  141. mySQL datetime field default now() fails
  142. odbc 3.51, Visual Studio 2003, odbc DataAdapter
  143. MySQL backup suggestions
  144. strange problem
  145. force order
  146. mysqld startup problem
  147. Anybody need SQL
  148. mysql / msaccess combo really odd time problems any help?
  149. CLIENT?
  150. Counting rows in a table HELP NEEDED
  151. Where to add AND statements help needed
  152. Can I perform multiple row join?
  153. birthday date problem
  154. Multiple Tables Help Needed
  155. birthday date problem
  156. Multiple Tables Help Needed
  157. Query problem help needed
  158. Finding primary key of record after INSERT
  159. Query problem help needed
  160. Locking table?
  161. Finding primary key of record after INSERT
  162. Locking table?
  163. mysqld got signal 11
  164. mysqld got signal 11
  165. mysqld got signal 11
  166. errors in db
  167. Help required to optimize few select command.
  168. Mysql, Get Back Your Youth!
  169. Mysql, Get Back Your Youth!
  170. Mysql, Get Back Your Youth!
  171. errors in db
  172. Help required to optimize few select command.
  173. Mysql, Get Back Your Youth!
  174. Mysql, Get Back Your Youth!
  175. Mysql, Get Back Your Youth!
  176. Mysql, Get Back Your Youth!
  177. Changing DATADIR
  178. Mysql, Get Back Your Youth!
  179. Mysql, Get Back Your Youth!
  180. ERROR 2013: Lost connection to MySQL server during query
  181. Mysql, Get Back Your Youth!
  182. Changing DATADIR
  183. Changing DATADIR
  184. ERROR 2013: Lost connection to MySQL server during query
  185. Mysql, Get Back Your Youth!
  186. Mysql, Get Back Your Youth!
  187. ERROR 2013: Lost connection to MySQL server during query
  188. Mysql, Get Back Your Youth!
  189. Mysql, Get Back Your Youth!
  190. Mysql, Get Back Your Youth!
  191. Mysql, Get Back Your Youth!
  192. Mysql, Get Back Your Youth!
  193. Move DB from PostgreSQL to MySQL
  194. Mysql, Get Back Your Youth!
  195. changed user privileges and now I can't log in - please help
  196. Move DB from PostgreSQL to MySQL
  197. changed user privileges and now I can't log in - please help
  198. Mysql, Get Back Your Youth!
  199. changed user privileges and now I can't log in - please help
  200. Need help importing part of a database
  201. GUIDs/uniqueidentifiers why not?
  202. changed user privileges and now I can't log in - please help
  203. Need help importing part of a database
  204. GUIDs/uniqueidentifiers why not?
  205. Bigger is Always MUCH Better! - TGJRy
  206. Bigger is Always MUCH Better! - romOI
  207. Bigger is Always MUCH Better! - fOgTN
  208. Bigger is Always MUCH Better! - TGJRy
  209. Bigger is Always MUCH Better! - romOI
  210. Bigger is Always MUCH Better! - fOgTN
  211. Bigger is Always MUCH Better! - romOI
  212. Bigger is Always MUCH Better! - qZLcP
  213. Bigger is Always MUCH Better! - fOgTN
  214. Bigger is Always MUCH Better! - FKWxd
  215. Bigger is Always MUCH Better! - qZLcP
  216. How to dump (quick) a table into another one.
  217. Bigger is Always MUCH Better! - qZLcP
  218. Any good reporting module ?
  219. Bigger is Always MUCH Better! - FKWxd
  220. How to dump (quick) a table into another one.
  221. Bigger is Always MUCH Better! - FKWxd
  222. Any good reporting module ?
  223. Port 3306 - can't get started
  224. Any good reporting module ?
  225. Bigger is Always MUCH Better! - HjTJJ
  226. How to dump (quick) a table into another one.
  227. Bigger is Always MUCH Better! - MTWyC
  228. Port 3306 - can't get started
  229. Bigger is Always MUCH Better! - uakkl
  230. Bigger is Always MUCH Better! - HjTJJ
  231. Bigger is Always MUCH Better! - MTWyC
  232. Port 3306 - can't get started
  233. MySQL dump help with version ;4.0.14-log
  234. Bigger is Always MUCH Better! - HjTJJ
  235. Bigger is Always MUCH Better! - uakkl
  236. order by - order of precedence?
  237. MySQL dump help with version ;4.0.14-log
  238. Bigger is Always MUCH Better! - MTWyC
  239. PHP or MySQL error? or it is ACID or Snort?? Please help
  240. Bigger is Always MUCH Better! - uakkl
  241. Repeateable read isolation level question
  242. order by - order of precedence?
  243. MySQL dump help with version ;4.0.14-log
  244. PHP or MySQL error? or it is ACID or Snort?? Please help
  245. 030828 mysql ended
  246. PHP or MySQL error? or it is ACID or Snort?? Please help
  247. order by - order of precedence?
  248. Repeateable read isolation level question
  249. mutiple table sum problem
  250. Repeateable read isolation level question
  251. help with mysql errors
  252. 030828 mysql ended
  253. help with mysql errors
  254. How to store timestamp in a column
  255. mutiple table sum problem
  256. how to rewrite this query without a subquery ?
  257. 030828 mysql ended
  258. How to store timestamp in a column
  259. how to rewrite this query without a subquery ?
  260. mutiple table sum problem
  261. help with mysql errors
  262. "Lost connection to MySQL server during query"
  263. View Implementation
  264. How to store timestamp in a column
  265. mysql log single database or user
  266. how to rewrite this query without a subquery ?
  267. "Lost connection to MySQL server during query"
  268. MySQL and transactions
  269. View Implementation
  270. MySQL and transactions
  271. selecting rows not within another table
  272. mysql log single database or user
  273. "Lost connection to MySQL server during query"
  274. selecting rows not within another table
  275. View Implementation
  276. MySQL and transactions
  277. mysql log single database or user
  278. 4.0.14 install problem: mysqld crashes
  279. selecting rows not within another table
  280. upgrade question
  281. If the mysql crash,how can I trace the log
  282. 4.0.14 install problem: mysqld crashes
  283. If the mysql crash,how can I trace the log
  284. Explain syntax
  285. Question about row level locking with InnoDB tables
  286. Explain syntax
  287. Question about row level locking with InnoDB tables
  288. upgrade question
  289. If the mysql crash,how can I trace the log
  290. Explain syntax
  291. How to Track error - Commands Out of Sync
  292. How to Track error - Commands Out of Sync
  293. Question about row level locking with InnoDB tables
  294. Syntax error.
  295. Syntax error.
  296. variables in select into outfile
  297. variables in select into outfile
  298. How to Track error - Commands Out of Sync
  299. Find & Delete Orphan Records
  300. Find & Delete Orphan Records
  301. Syntax error.
  302. Possible regexp bug in 4.1a?
  303. Replication with multiple servers in Mysql ?
  304. variables in select into outfile
  305. Possible regexp bug in 4.1a?
  306. Replication with multiple servers in Mysql ?
  307. Find & Delete Orphan Records
  308. UCS2 question
  309. Possible regexp bug in 4.1a?
  310. UCS2 question
  311. Replication with multiple servers in Mysql ?
  312. UCS2 question
  313. How to tell
  314. InnoDB Error ib_logfile0 of different size
  315. InnoDB Error ib_logfile0 of different size
  316. error 1044 on database restore
  317. error 1044 on database restore
  318. How to tell
  319. InnoDB Error ib_logfile0 of different size
  320. InnoDB can't use system's RAM as specified
  321. InnoDB can't use system's RAM as specified
  322. Need to delete duplicate records.
  323. error 1044 on database restore
  324. InnoDB can't use system's RAM as specified
  325. Running Average
  326. Need to delete duplicate records.
  327. Running Average
  328. Finding warnings/skips from mysqlimport
  329. Finding warnings/skips from mysqlimport
  330. simple query
  331. MySQL Books
  332. simple query
  333. Multi-table query in one select - possible?
  334. MySQL Books
  335. Multi-table query in one select - possible?
  336. Converting a colum to a unique column
  337. Simple Join?
  338. Converting a colum to a unique column
  339. Upgrade from 3.23 to 4 in Linux
  340. Simple Join?
  341. mailbody add a url
  342. Upgrade from 3.23 to 4 in Linux
  343. pswd help
  344. mailbody add a url
  345. mysql server crashes - high context switch rate - large 'merge' table
  346. pswd help
  347. "union" question
  348. "union" question
  349. mysql server crashes - high context switch rate - large 'merge' table
  350. OLAP Proposal for MySQL
  351. "union" question
  352. OLAP Proposal for MySQL
  353. Explanation of multiple-column indexes
  354. Explanation of multiple-column indexes
  355. own privileges
  356. own privileges
  357. Fw: PHP or Perl? (or Rebol via TCP/IP)
  358. Fw: PHP or Perl? (or Rebol via TCP/IP)
  359. user types
  360. user types
  361. Version 3.x tables with a new 4.0.x engine
  362. Version 3.x tables with a new 4.0.x engine
  363. How do I fix a .frm file?
  364. How do I fix a .frm file?
  365. How many records can a single MySql Table Hold.
  366. How many records can a single MySql Table Hold.
  367. How many records can a single MySql Table Hold.
  368. Replication from 2 Master
  369. Local Host vs ISP Host Name In Connect Command
  370. Replication from 2 Master
  371. Local Host vs ISP Host Name In Connect Command
  372. Fw: Borland may have fixed the dbExpress driver for MySQL transactions
  373. Union and Order By give strange results in Mysql 4.0.13
  374. Fw: Borland may have fixed the dbExpress driver for MySQL transactions
  375. Lots of FULLTEXT stuff (suggestions)
  376. Union and Order By give strange results in Mysql 4.0.13
  377. MySql via OLEDB question
  378. Lots of FULLTEXT stuff (suggestions)
  379. Lots of FULLTEXT stuff (suggestions)
  380. MySql via OLEDB question
  381. finding out what localhost is
  382. MySql via OLEDB question
  383. finding out what localhost is
  384. naming standards
  385. finding out what localhost is
  386. linked db
  387. naming standards
  388. naming standards
  389. linked db
  390. UPDATE based on value in another table
  391. Doing Differential backup
  392. linking databases
  393. UPDATE based on value in another table
  394. UPDATE based on value in another table
  395. Slow results with simple, well-indexed query
  396. Doing Differential backup
  397. linking databases
  398. differance between InnoDB and MyISAM tables ?
  399. Doing Differential backup
  400. linking databases
  401. help installing DBI modules
  402. differance between InnoDB and MyISAM tables ?
  403. ERROR: 1130 Need help changing privileges
  404. Slow results with simple, well-indexed query
  405. differance between InnoDB and MyISAM tables ?
  406. differance between InnoDB and MyISAM tables ?
  407. differance between InnoDB and MyISAM tables ?
  408. help installing DBI modules
  409. ERROR: 1130 Need help changing privileges
  410. Upgrading 3.23->4.0 under WinXP ?
  411. can't start mysqld
  412. Upgrading 3.23->4.0 under WinXP ?
  413. progressive number
  414. innodb use outside of explicit transactions
  415. Named pipe vs TCP/IP speed
  416. Forwarding Insert/Updates from Slave to Master
  417. can't start mysqld
  418. can't start mysqld
  419. privilege unstable
  420. progressive number
  421. My SQL Search
  422. progressive number
  423. tellme Timestamp
  424. innodb use outside of explicit transactions
  425. Timestamp
  426. Named pipe vs TCP/IP speed
  427. Forwarding Insert/Updates from Slave to Master
  428. Forwarding Insert/Updates from Slave to Master
  429. mysql logging compiled in?
  430. privilege unstable
  431. My SQL Search
  432. privilege unstable
  433. My SQL Search
  434. Thank you!
  435. tellme Timestamp
  436. Problem with a query - Join doesn't seem to work well
  437. tellme Timestamp
  438. Search?
  439. Timestamp
  440. Timestamp
  441. subselect doesnt work
  442. lower_case_table_names not working for SELECT
  443. mysql logging compiled in?
  444. mysql logging compiled in?
  445. Problem with a query - Join doesn't seem to work well
  446. Thank you!
  447. Thank you!
  448. Search?
  449. Problem with a query - Join doesn't seem to work well
  450. Using joins to create code from E- ER relationships
  451. Search?
  452. subselect doesnt work
  453. ibdata1 is close to disk size
  454. subselect doesnt work
  455. How to Dispaly Column heading after every 15 records display
  456. lower_case_table_names not working for SELECT
  457. lower_case_table_names not working for SELECT
  458. data from linked tables
  459. Using joins to create code from E- ER relationships
  460. Using joins to create code from E- ER relationships
  461. ibdata1 is close to disk size
  462. ibdata1 is close to disk size
  463. How to Dispaly Column heading after every 15 records display
  464. How to Dispaly Column heading after every 15 records display
  465. External Access
  466. where are my tables?
  467. How To See Sql Statements send to server ?
  468. data from linked tables
  469. where are my tables?
  470. External Access
  471. How To See Sql Statements send to server ?
  472. Problem with MBREquals function
  473. Delivery Status Notification
  474. Suitable Driver Error
  475. Replication Problem (XP+mysql4.0.14)
  476. Problem with MBREquals function
  477. Delivery Status Notification
  478. Suitable Driver Error
  479. Replication Problem (XP+mysql4.0.14)
  480. Setting up MySQL on Mac OS X
  481. Left join on my own list, don't know the syntax
  482. Setting up MySQL on Mac OS X
  483. Delivery Status Notification
  484. Left join on my own list, don't know the syntax
  485. linking databases
  486. Delivery Status Notification
  487. confused very very confused
  488. When to use NULL as default value
  489. linking databases
  490. Concatenate Columns
  491. confused very very confused
  492. When to use NULL as default value
  493. Concatenate Columns
  494. sum()/Group by Query Help
  495. PHP API Question.
  496. sum()/Group by Query Help
  497. subselect doesnt work
  498. PHP API Question.
  499. restricted word????
  500. subselect doesnt work
  501. Imran Javed/Kamino is out of the office.
  502. restricted word????
  503. Imran Javed/Kamino is out of the office.
  504. Imran Javed/Kamino is out of the office.
  505. Slow results with simple, well-indexed query
  506. Slow results with simple, well-indexed query
  507. MySQL running out of date
  508. MySQL running out of date
  509. How to create a stop word file?
  510. Erwin Purner/L5A/EAGA/EAG/AT ist außer Haus.
  511. Erwin Purner/L5A/EAGA/EAG/AT ist außer Haus.
  512. hidden tables?
  513. hidden tables?
  514. Erwin Purner/L5A/EAGA/EAG/AT ist außer Haus.
  515. Erwin Purner/L5A/EAGA/EAG/AT ist außer Haus.
  516. Optimizing Mysql for large tables
  517. Optimizing Mysql for large tables
  518. how to show all locks on a table?
  519. how to show all locks on a table?
  520. Need For SPEED
  521. Karlheinz Cometto/L7A/EAGA/EAG/AT ist auf Urlaub
  522. Need For SPEED
  523. mysqlclient library
  524. Karlheinz Cometto/L7A/EAGA/EAG/AT ist auf Urlaub
  525. mysqlclient library
  526. Karlheinz Cometto/L7A/EAGA/EAG/AT ist auf Urlaub
  527. How to exclude table(s) when using mysqldump
  528. SQL Q: Concatenate multiple rows on same column.
  529. How to exclude table(s) when using mysqldump
  530. SQL Q: Concatenate multiple rows on same column.
  531. Slow results with simple, well-indexed query
  532. Join 3 Tables - distinct results
  533. Slow results with simple, well-indexed query
  534. select from table using 2 columns as unique
  535. Join 3 Tables - distinct results
  536. select from table using 2 columns as unique
  537. select from table using 2 columns as unique
  538. Handling Very Large Databases in MySQL
  539. Handling Very Large Databases in MySQL
  540. Handling Very Large Databases in MySQL
  541. MyODBC 3.51 executing multiple SQL statements
  542. Adding up DATETIME field
  543. Adding up DATETIME field
  544. Re[2]: SHOW DATABASES works in 4.0.14
  545. Re[2]: SHOW DATABASES works in 4.0.14
  546. Problem installing MYSql 4.0.12 on MAC OSX 10.1.3
  547. MyODBC 3.51 executing multiple SQL statements
  548. Adding up DATETIME field
  549. Re[2]: SHOW DATABASES works in 4.0.14
  550. Problem installing MYSql 4.0.12 on MAC OSX 10.1.3