/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

1 vote209 views1 answer
Alter table column size oracle
SQL
0 vote202 views1 answer
User defined variables in sql
SQL
0 vote601 views2 answers
Zsh: command not found: mysq
SQL
0 vote199 views1 answer
Install ms sql server management studio
SQL
10 votes193 views3 answers
Insert into auto increment mysql
SQL
1 vote222 views1 answer
Mysql workbench in ubuntu 14.04
SQL
6 votes247 views3 answers
Psql show columns of table
SQL
1 vote204 views1 answer
Increase date by one day in sql oracle
SQL
0 vote208 views1 answer
How to print mysql query of codeigniter query builder
SQL
13 votes221 views2 answers
Sqlite rename table
SQL

Share