Delete all rows from table sql

Delete all records from table

DELETE FROM table_name;

-- Deletes all records where `columnName` matches the values in brackets.
DELETE FROM tableName WHERE columnName IN ('val1', 'val2', 'val3');

-- Quick, no possible rollback
TRUNCATE TABLE my_table;
-- With rollback
DELETE FROM my_table;
COMMIT;

DELETE FROM table1 #delete all record

DELETE FROM my_table WHERE col1 > 2;
DELETE FROM my_table WHERE col1 IS NOT NULL;

DELETE FROM category where category_model is  'NULL';

Similar codes

9 votes138 views6 answers
Sql add column with default value
SQL
17 votes158 views6 answers
Get last record in sql
SQL
0 vote134 views1 answer
Oracle procedure chain step
SQL
1 vote153 views1 answer
Nvl postgres
SQL
0 vote154 views1 answer
Set Mamp mysql globally
SQL
1 vote128 views1 answer
Oracle first row
SQL
0 vote134 views1 answer
Mysql database hyphen
SQL
0 vote124 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
1 vote144 views1 answer
Key validation sql
SQL
1 vote137 views3 answers
Sql union
SQL