Truncate all tables in a MySQL database in one command?

Question

Is there any query (command) to truncate all the tables in a database in a single operation? I need to know if I can do it with one single query.

Answer 1

Use phpMyAdmin in this way:

Database View => Check All (tables) => Empty

If you need to ignore foreign key checks, you can uncheck the box that says:

[ ] Enable foreign key checks

You'll need to be running at least version 4.5.0 or higher to get this checkbox.

Hope it works !

Want to be a SQL expert? Come and join this SQL Certification by Intellipaat.

You can check out the below MySQL Tutorial video for better understanding.