delete all lines of a table mysql code example Example 1: delete all records from table DELETE FROM table_name; Example 2: delete all content in table mysql TRUNCATE tablename