/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

0 vote312 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
1 vote330 views1 answer
Date in where on datetime column clause mysql
SQL
2 votes332 views3 answers
Sql server: how to concatenate column data using comma
SQL
3 votes325 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
2 votes339 views2 answers
Get all tables using like
SQL
0 vote327 views1 answer
Python list from sql
SQL
0 vote319 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
3 votes305 views2 answers
Mysql HAVING
SQL
14 votes314 views3 answers
SQL trim
SQL
0 vote330 views2 answers
Drop tables from local table database postgres
SQL

Share