MySQL: delete all contents in the db

[Peter Primrose]

does anyone know of any command that clear/delete/remove all the content in the dataase (but do not touch the tables) so the end result will be empty tables.

thanks
peter

[Shailesh Chandra]

In Oracle I use to genrate the script with help of a query.
you will have to write script using truncate

Shailesh

[Peter Primrose]

can you show an example of a script you wrote.
thanks

[Shailesh Chandra]

As I mentioned I did same in Oracle

Select TABLE_NAME form user_tables gives me all table in schema


so I made a query like


select distinct 'Truncate table ' || TABLE_NAME || ';' from USER_TABLES;
and I saved the output of query in a sql file

Then I could execute sql file on sql plus

Shailesh

[miguel lisboa]

see this