Answers for "delete all values not used SQL"

SQL
1

sql delete all values in a column

UPDATE TableName SET ColumnName = NULL
Posted by: Guest on October-03-2020
0

delete all records from table except sql

DELETE FROM my_table WHERE col1 > 2;
DELETE FROM my_table WHERE col1 IS NOT NULL;
Posted by: Guest on May-08-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language