/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

244 votes378 views14 answers
Sql n insert
SQL
0 vote175 views1 answer
This week mysql
SQL
1 vote161 views2 answers
Oracle list partitioned tables
SQL
0 vote147 views2 answers
Sql day from datetime
SQL
9 votes181 views3 answers
Date format in sql
SQL
1 vote213 views1 answer
Connect to mysql database ubuntu
SQL
0 vote159 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote178 views1 answer
Sql query inline if
SQL
25 votes163 views5 answers
Date in mysql
SQL
0 vote145 views1 answer
Initcap in sql
SQL

Share