delete all rows from table mysql
-- Quick, no possible rollback TRUNCATE TABLE my_table; -- With rollback DELETE FROM my_table; COMMIT;
remove all records from table mysql
/* Will delete all rows from your table. Next insert will take next auto increment id. */ DELETE from tableName; /* Will delete all rows from your table but it will start from new row with 1. */ TRUNCATE tableName;
delete all content in table mysql
TRUNCATE tablename
remove all data from table mysql
TRUNCATE table_name;