MySQL Forums
Forum List  »  Newbie

truncate all tables?
Posted by: Anti Body
Date: August 27, 2008 08:43PM

is there a query to do that?

I can do this:

SELECT table_name
FROM INFORMATION_SCHEMA.tables
WHERE table_schema = 'db_name'

Can I then truncate each somehow?

Options: ReplyQuote


Subject
Written By
Posted
truncate all tables?
August 27, 2008 08:43PM
August 27, 2008 08:48PM
August 28, 2008 05:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.