1-- Quick, no possible rollback
2TRUNCATE TABLE my_table;
3-- With rollback
4DELETE FROM my_table;
5COMMIT;
1DELETE FROM table_name; //will delete the table data without affecting the table structue
1-- Deletes all records where `columnName` matches the values in brackets.
2DELETE FROM tableName WHERE columnName IN ('val1', 'val2', 'val3');
1delete from yourTableName where yourColumnName NOT
2IN(‘yourValue1’,‘yourValue2’,‘yourValue3’,.........N);