Posted by Tom on 07/18/07 20:17

On Wed, 18 Jul 2007 09:50:24 -0700, laredotornado@zipmail.com wrote...
>
>Hi,
>
>I'm using php 4.4.4 with MySQL 5.0 on Linux. Short of dropping the
>database, which my user does not have privileges to, what is the
>simplest way to purge all data from the db? By this I mean not only
>deleting data from tables but also the tables themselves?
>
>Thanks, - Dave
>


In MySQL I think you can display all tables by using "SHOW TABLES;" From that
list you can use "DROP TableName;" but may have to enable user permissions to
drop tables.


Tom
--
Newsguy Takes Usenet Cellular!
Download your favorite photos, songs or movie files
Send the files or links your cell/PDA
http://newsguy.com/cellphone.htm

• Next in forum: Re: rename all tables in database newbie question
• Prev in forum: Dropping all tables in a database?
• Thread view: Re: Dropping all tables in a database?

[Reply to this message]