Re: Droping multiple tables by a pattern in the table name

2006-01-18 Thread Gleb Paharenko
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

Droping multiple tables by a pattern in the table name

2006-01-17 Thread Yair Zohar
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