How to delete from All tables in database

[rahuljagtap5]

How to delete from all tablesin database using single querry

[r035198x]

Deleting from tables invokes some constraints checks.
If you are using some fron end language then you might want to do it using that instead and list the tables in an order that ensures that there are no constraint violations.

[coolsti]

You might not have any constraint checking problems, depending on what type of database tables you are using. Mysql MyISAM tables do not check constraints. So in this case you can just delete from all the tables in any order. Since you wish to clear out the database completely, the end result does not matter.

[chaarmann]

if you want to delete all tables, you can just delete the corresponding database files. (all files in the directory with your schema name).

But the question is how to do it with a single query.
There is no such possibility as far as I know.

But you can do it with a loop:
1.) Make an inquiry to get the name of all database tables.
2.) For each table name "tabName" generate a statement "delete * from tabName" and execute it. You can even do it faster by truncating the table.