how to drop all rows in mysql table code example Example 1: delete all records from table DELETE FROM table_name; Example 2: delete all content in table mysql TRUNCATE tablename