/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

2 votes227 views1 answer
Mysql application.properties spring boot
SQL
3 votes212 views1 answer
Select without null values sql
SQL
1 vote227 views1 answer
Access the postgres psql
SQL
16 votes235 views1 answer
Mysql smallint range
SQL
0 vote216 views1 answer
1 column values in to 1 single row in sql
SQL
6 votes216 views3 answers
Mysql server is not starting xampp
SQL
0 vote235 views1 answer
Php select data from mysql database without column name
SQL
15 votes221 views7 answers
MYSQL
SQL
1 vote226 views1 answer
Sql server 2016 reseed identity
SQL
2 votes275 views1 answer
Python sql
SQL

Share