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]