Truncate all tables in a MySQL database in one command?
Truncate all tables in a MySQL database in one command?
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`