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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
