Hello. My advice doesn't solve your issue, but if you had a 5.0, you would have been able to use INFORMATION_SCHEMA to retrieve the table names and assign them to variables. Then using prepared statements and variables you can dynamically drop a table. And at the end, you can put all this stuff in the stored procedure. See: http://dev.mysql.com/doc/refman/5.0/en/information-schema.html http://dev.mysql.com/doc/refman/5.0/en/sqlps.html http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html
Yair Zohar wrote: > > Hello, > I'm using mysql 4.1.14-standard. > I would like to drop multiple tables in one or few queries. I don't > have an easy way to predict their names (I have a way to find their > names, but it's by using software and I prefer doing it with mysql). > All of the table names have a fixed part which I know, and I thought of > using the fixed, known part of the names to delete all of these tables > at once. > Can someone lead my to the way doing it with a mysql queries? > I thought of using the combination of 'SHOT TABLES LIKE '%regexp%'; and > DROP, but I don't know how to combine them. > Thanks ahead, > Yair. > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]