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:

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

| a b c d e | | a b c | 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]

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: "

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: &quo

MySQL Error

27; or '--no-defaults --help' for a list of available o I am using mysql version 3.23 mysql> select version(); +-+ | version() | +-+ | 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

DELETE SQL Statement.

query 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,

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 chec

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 bil