Page 1 of 1

Dropping multiple tables

Posted: Wed Feb 18, 2004 6:19 am
by yaron
Hello all,

My wish is a simpel one (i hope).
I need a mysql query to drop multiple tables from my database.
I have a prefix of the name of several tables and I wish to drop all tables that begins with that name.

is this possible?
if not how can I get all tables that begins with that prefix and then delete them one by one?

Thx all