Howdy --
How can I drop all tables in a databases?
How can I drop tables beginning with foo_
Note, I don't have permissons to just drop the db.
TX,
David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
David Jackson [EMAIL PROTECTED] wrote:
Howdy --
How can I drop all tables in a databases?
Get list of table names with SHOW TABLES FROM db_name and compose DROP TABLE statement.
How can I drop tables beginning with foo_
In this case you can use SHOW TABLES .. LIKE 'foo\_%' statement to get