List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:July 15 1999 8:45pm
Subject:Re: dropping lots of tables at once?
View as plain text  
Otis Gospodnetic wrote:
> Hi,
> If there a way to drop more than one table at a time?
> I know I can do:
> mysql> drop table T1,T2,Tn;
> But I'm hoping that there is something that will let me do something like:
> mysql> drop table T*;
> Thanks,
> Otis Gospodnetic

Hi Otis

Wildcards are not allowed for table names.

But you can DROP all tables within one database, by DROPing the database and recreate it


PS: Sorry for the late answer, I was on vacation.

dropping lots of tables at once?Otis Gospodnetic8 Jul
  • Re: dropping lots of tables at once?Christian Mack16 Jul