Re: SOLVED(sort of): OT: deleting tables from mysql using wildcard

2006-06-14 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kent West wrote: > Ron Johnson wrote: >> Kent West wrote: [snip] > Not as much work as it could have been; way more than it should > have been. A simple "drop table phpWeb*" would have been SO much > easier. Oh, well, that's a mysql issue, not Debian.

SOLVED(sort of): OT: deleting tables from mysql using wildcard

2006-06-14 Thread Kent West
Ron Johnson wrote: > Kent West wrote: > >> I have a lot of tables in a mysql database starting with "phpWeb"; I > >> want to delete them. I can delete them one-by-one with a command like: > >> > >>drop table phpWebmod_modules; > >> > >> Rather than trying to delete all 20-30 similar tables, a w

Re: OT: deleting tables from mysql using wildcard

2006-06-13 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kent West wrote: > I have a lot of tables in a mysql database starting with "phpWeb"; I > want to delete them. I can delete them one-by-one with a command like: > >drop table phpWebmod_modules; > > Rather than trying to delete all 20-30 similar t

OT: deleting tables from mysql using wildcard

2006-06-13 Thread Kent West
I have a lot of tables in a mysql database starting with "phpWeb"; I want to delete them. I can delete them one-by-one with a command like: drop table phpWebmod_modules; Rather than trying to delete all 20-30 similar tables, a wildcard command would be really nice hear. I've been googling f