/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 votes148 views1 answer
Remove root password mysql
SQL
1 vote172 views1 answer
Ora-01109 database not open in oracle 19c
SQL
12 votes170 views6 answers
Distinct in sql server
SQL
-1 vote145 views1 answer
How to dump .csv file into mysql
SQL
0 vote135 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
13 votes136 views2 answers
Sqlite rename column
SQL
0 vote154 views1 answer
Python dictionary to sql update
SQL
1 vote128 views1 answer
Join first name and last name sql
SQL
0 vote133 views1 answer
Oracle list of long running queries
SQL
2 votes150 views1 answer
Import large .sql files into lampp
SQL

Share