mysql remove all data in code example
Example 1: delete all rows from table mysql
-- Quick, no possible rollback
TRUNCATE TABLE my_table;
-- With rollback
DELETE FROM my_table;
COMMIT;
Example 2: delete all content in table mysql
TRUNCATE tablename