Clear Table Mysql Code Example

Example 1: clear a table in mysql

truncate tableName

Example 2: 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;  -- -------------------------------------------------------- -- Otherwise: DELETE FROM tblYourTable WHERE condition;  -- Or  DELETE FROM tblYourTable LIMIT row_count;

Example 3: 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;

Example 4: delete all content in table mysql

TRUNCATE tablename

Example 5: how to delete all the rows in a table without deleting the table in mysql

delete from tableName;