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