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

4 votes134 views2 answers
REST API
SQL
0 vote127 views1 answer
Sql server set complex constraints
SQL
-1 vote128 views1 answer
Partial search in sql
SQL
2 votes89 views1 answer
Sql select min value from multiple columns
SQL
0 vote134 views1 answer
Sqlite3_open_v2
SQL
2 votes129 views1 answer
Change primary key sql
SQL
1 vote123 views1 answer
Sql select all from one table and one column from another
SQL
1 vote86 views1 answer
Psql kill pid
SQL
0 vote145 views1 answer
Hallo
SQL
0 vote185 views1 answer
Sql ssrs
SQL