RE: Delete tables
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
You cannot directly drop tables by wildcards. If you wanted to do that, you would have to do some programming in your client and use the output of SHOW TABLES LIKE 'pattern' To construct some SQL like DROP TABLE table1,tables2, ... John B. -----Original Message----- From: ascll [mailto:[email protected]] Sent: Tuesday, 3 January 2006 4:33 PM To: win32@ lists.mysql.com Subject: Delete tables Greetings, Could I make use of MySQL query to delete all tables start with '_' (underscore)? Thanks in advance and I'm using MySQL 4.1.16. __________________________________________ Yahoo! DSL - Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]