SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE test_seq ( -- "When you define a column as INTEGER PRIMARY KEY, -- it will auto-increment whenever you insert NULL into that column" id integer PRIMARY KEY, val varchar NOT NULL ); INSERT INTO test_seq(val) VALUES ('some value'), ('other value'); SELECT * FROM test_seq; BEGIN TRANSACTION; INSERT INTO test_seq(val) VALUES ('value3'), ('value4'), ('value5'); SELECT * FROM test_seq; ROLLBACK; INSERT INTO test_seq(val) VALUES ('value6'); SELECT * FROM test_seq;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear