/SQL/Sql delete all except

Sql delete all except

Delete all records from table except sql

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

0

Delete all records from table except sql

delete from yourTableName where yourColumnName NOT
IN(‘yourValue1’,‘yourValue2’,‘yourValue3’,.........N);

0

Sql delete all except

DELETE FROM Pessoa
WHERE ID = 12

0

Similar codes

4 votes122 views2 answers
Error loading MySQLdb module.
SQL
4 votes106 views4 answers
Rollback in sql
SQL
1 vote114 views1 answer
What is intersect
SQL
1 vote113 views1 answer
Primary key with prefix sql
SQL
10 votes227 views4 answers
Mysql if else
SQL
0 vote124 views1 answer
Sql period overlap
SQL
1 vote133 views1 answer
UseSqlServer no definition
SQL
0 vote113 views1 answer
How to move a columns location in mysql
SQL
0 vote127 views1 answer
Template MySQL Zabbix agent
SQL
5 votes119 views1 answer
Sql integer to serial
SQL

Share