Dropping multiple tables
Posted: Wed Feb 18, 2004 6:19 am
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
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