Tags
Asked 2 years ago
1 Jul 2021
Views 238
Cleora

Cleora posted

Truncate all tables in a MySQL database in one command?

Truncate all tables in a MySQL database in one command?
sarah

sarah
answered Jul 2 '21 00:00


 TRUNCATE `tablename` 


TRUNCATE will the needed to the empty the table without deleting the table

if you want to delete the table as well with the records you can use DROP query


 DROP `tablename` 
Post Answer