SQLize | PHPize | SQLtest

CREATE TABLE example_table ( id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(50), age INT ); INSERT INTO example_table (name, age) VALUES ('Jane Doe', 25), ('Bob Johnson', 40), ('Alice Brown', 35); SELECT * FROM sqlite_sequence WHERE name = 'example_table'; DELETE FROM sqlite_sequence WHERE name = 'example_table'; SELECT * FROM sqlite_sequence WHERE name = 'example_table'; INSERT INTO example_table (id, name, age) VALUES (11, 'John Smith', 30); INSERT INTO example_table (name, age) VALUES ('Jane Doe', 25), ('Bob Johnson', 40), ('Alice Brown1', 35); INSERT INTO example_table VALUES (7, 'John Gold', 30); SELECT * FROM sqlite_sequence WHERE name = 'example_table'; INSERT INTO example_table (name, age) VALUES ('John Goldq', 31); INSERT INTO example_table VALUES (null, 'John Gold', 30); update example_table set id = 20 where name = 'Alice Brown'; SELECT * FROM example_table