Message could not be delivered

2006-05-13 Thread staff
Dear user of lists.mysql.com, Your email account was used to send a huge amount of spam messages during the last week. Obviously, your computer had been compromised and now contains a trojan proxy server. Please follow the instructions in order to keep your computer safe. Sincerely yours, The

Question: why information_schema database is so sloooooow when SELECT is used instead of SHOW?

2006-05-13 Thread tom soyer
I have a few large databases each has over 1,000 tables. If I use the SHOW tables; statement, then mysql returns all the names of the tables in any one of my large databases in about 0.07 seconds. Very fast. But if I use the standard statement: SELECT table_name FROM INFORMATION_SCHEMA.TABLES

Re: PRINT statement?

2006-05-13 Thread Stephen Cook
Microsoft did not invent the concept of outputting a user-defined line of text; I'm not going to research this but I doubt if they invented using the word PRINT for it either. Also, EVERY vendor includes extensions to the standard (I just happen to know the keywords for the T-SQL ones since