delete all records from table except sql

VasteMonde answered on May 8, 2021 Popularity 10/10 Helpfulness 4/10

answer delete all records from table except sql

Comment

DELETE FROM my_table WHERE col1 > 2;
DELETE FROM my_table WHERE col1 IS NOT NULL;

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: except records row sql

Link to this answer
Share Copy Link

Contributed on May 08 2021

VasteMonde

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.