tom poe <tompoe@stripped> wrote:
>
> What's the command for dropping multiple tables?
>
> Example:
> 12 tables that all start with:
> phpbb_
>
> What? Well, the install isn't going as planned. I am having to
> reinstall as I try to work out script path (I think) or some other piece
> of info that isn't entered correctly, yet.
>
> Anyway, DROP TABLE tablename; is one table. I want to drop all the
> tables without typing them, but using DROP TABLE phpbb*; doesn't work.
>
You can't use wildcards in the DROP TABLE command.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
