Drop Multiple Tables

[bjblackmore]

Hi,

Is it possible to drop multiple tables? I have about 50 tables with the name my_tbl1, my_tbl2....my_tbl50 etc
I'd like to do something like DROP TABLE LIKE 'my_%';
Is this possible? Or is something like it possible?

Cheers

Ben

[Lars_Berg]

NO, you can't have wildcards in drop statements. You must drop each table individually.

[carrot]

solution 1:
- u can drop the database and re-create the new one

solution 2:
- use "mysql < droptables.sql" command (ie. all the SQLs to drop tables should be included in the droptables.sql)