Exercise: Auto ID Table
Create table with auto-incrementing ID.
Solution
sql
1CREATE TABLE messages (
2 id INTEGER PRIMARY KEY AUTOINCREMENT,
3 content TEXT
4);
5
6INSERT INTO messages (content) VALUES ('Hello');
7INSERT INTO messages (content) VALUES ('World');