Re: MySQL on large server

I rade some where that in the lateste MySQL versopn you can use 1000 to 1400 concurrent connection.Pls cross check in mysql site. - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: mysql list [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 5:36 PM

Re: Select * from names where words(name) = 3

| a b c | | a d c | a d c | | a d c | a d c e | +-+---+ 4 rows in set (0.00 sec) Enjoy Abhi - Original Message - From: Clyde England [EMAIL PROTECTED] To: Dan Nelson [EMAIL PROTECTED] Cc: [EMAIL

Re: Disproportionately slow, but simple, query

[tracking_id] 3. flush tables 4.flush table threads 5. User PROPER DATA TYPES in your table. like if you can use tinyint or smallint as compare to INT then use that one etc. Just try that one and send the table description and which version r u using Abhi- - Original Message - From: Jim

Re: Disproportionately slow, but simple, query

[tracking_id] 3. flush tables 4.flush table threads 5. User PROPER DATA TYPES in your table. like if you can use tinyint or smallint as compare to INT then use that one etc. Just try that one and send the table description and which version r u using Abhi- - Original Message - From: Abhi

MySQL Error

() | +-+ | 3.23.49-log | +-+ 1 row in set (0.00 sec) ptions 021010 10:30:41 mysqld ended Please send an email regarding this problem .I appriciate if any one will help me. Thanks Regards! Abhi - Before posting, please

DELETE SQL Statement.

for deleting duplicate records. Thanks Regards! Abhi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

Delete sql statement

Could you pls let me know how to delete duplicate records in a table? Pls send SQL query. Thanks! Abhi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

sql date function

Could you pls send me answer of my question 1.How to convert this 10-Sep-2003 in a -MM-DD sql format effeciently.Like it should be 2003-09-10. Thanks, Abhi - Before posting, please check: http://www.mysql.com

Table Design!!

Dear MySQL User, I am sending the table schema of 5 tables.Here pid (partner ID) is in the top layer, aid (Affiliate ID) is in the middle layer and uid (User Id OR Customer ID) is in the bottem layer.User may promoted to Affiliate and affiliate may promoted to partner.We have to store there