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 (name, age) VALUES ('John Gold', 30);
SELECT * FROM sqlite_sequence WHERE name = 'example_table';