[devtalk] MySQL drop table multiple

[David Precious]

On 04/03/2009 05:08 PM, joseph-harris wrote:
> I am left wit h the option I least wanted, but that always 
> seemed inevitable. So I have 50 tables to delete, all 
> starting debtwiki_ .   It seems that DROP TABLE debtwiki_*; 
> is too complex.
> 
> Is there a way to drop them in one go?


Assuming they're all in a database which isn't used for anything else,
'DROP DATABASE databasename' ought to do the trick for you :)

If they're not, then... um... why? :)