RE: [PHP-DB] DROP tables with prefix match
| From: | Beau Lebens | Date: | Thu, 16 May 2002 01:59:10 +0000 |
| Subject: | RE: [PHP-DB] DROP tables with prefix match | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19208@lists.php.net to get a copy of this message | ||
if it's only a one-off thing, you could use php to get all table names
(mysql_list_tables) and then go thru and create an array of the names that
match your criteria, then go thru that array and DROP each one progressivly.
HTH
Beau
// -----Original Message-----
// From: John Hughes [mailto:jlhughes@yahoo.com]
// Sent: Thursday, 16 May 2002 7:41 AM
// To: php-db@lists.php.net
// Subject: [PHP-DB] DROP tables with prefix match
//
//
// I need to rebuild a PHP-mySQL site that has an extensive table
// structure. Is there a way to DROP all tables that start with a
// certain prefix?
//
// __________________________________________________
// Do You Yahoo!?
// LAUNCH - Your Yahoo! Music Experience
// http://launch.yahoo.com
//
// --
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, visit: http://www.php.net/unsub.php
//