delete record by id sql code example

Example 1: delete record by id sql

DELETE FROM table_name WHERE condition;

Example 2: delete record by id sql

CREATE TABLE my_table (
	my_id INT NOT NULL,  
  	name VARCHAR(100)
);

DELETE FROM my_table WHERE my_id = 100;
COMMIT;				-- if autocommit is off