RE: [PHP] Dropping Tables
| From: | John W. Holmes | Date: | Mon, 30 Dec 2002 03:21:06 +0000 |
| Subject: | RE: [PHP] Dropping Tables | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-129622@lists.php.net to get a copy of this message | ||
> Basically just do a a php script the sends the sql "show tables";
>
> Then do a strchr() to see if "a" is the first letter in the resuts and
if
> so do a delete table.
>
> Just yo play safe do a dump of your db first.
Or even better, use SHOW TABLES LIKE 'a%' to just get the a* tables and
drop each one.
How do you know whether it's an "active" a* table or not? Will you be
dropping a table that someone is actually using?
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/