dropping multiple tables
Posted: Thu Feb 19, 2004 5:23 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