DELETE FROM table_name WHERE column_name BETWEEN value 1 AND value 2; Another way to delete multiple rows is to use the IN operator. DELETE FROM table_name WHERE column_name IN (value 1, value 2, value 3, etc…); If you want to delete all records from the table then you can use this syntax
Anonymous Answered question September 19, 2024
Write your answer.
DELETE FROM table_name WHERE column_name BETWEEN value 1 AND value 2;