SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete CREATE TABLE tbl (id int primary key AUTO_INCREMENT, val varchar(64)); -- add single record INSERT INTO tbl (val) VALUES ('Val1'); -- check single record exists SELECT * FROM tbl; -- try to remove single record DELETE tbl.* FROM tbl JOIN tbl tbl1 ON tbl.id <> tbl1.id WHERE tbl.id =1; -- check it still exists SELECT * FROM tbl; -- add more records INSERT INTO tbl (val) VALUES ('Val2'), ('Val3'); SELECT * FROM tbl; -- try to delete first record again DELETE tbl.* FROM tbl JOIN tbl tbl1 ON tbl.id <> tbl1.id WHERE tbl.id = 1; -- and miracle. It's deleted SELECT * FROM tbl;