What do you want to save?
Add Code snippet
New code examples in category SQL
-
Bulat M. 2021-08-27 18:11:02
mysql empty a table
-- If you do not need a condition or limit the rows: TRUNCATE TABLE tblYourTable; -- Not Foreign key constrained -- Or SET FOREIGN_KEY_CHECKS = 0; TRUNCATE YourTable1; TRUNCATE YourTable2; SET FOREIGN_KEY_CHECKS = 1; -- ------------------------------... Add solution