CREATE TABLE people ( first_name text NOT NULL, last_name text NOT NULL );
INSERT INTO people (first_name, last_name) VALUES ('John', 'Doe');
SELECT rowid, first_name, last_name FROM people;
DROP TABLE people; CREATE TABLE people ( person_id INTEGER PRIMARY KEY, first_name text NOT NULL, last_name text NOT NULL );
INSERT INTO people ( person_id, first_name, last_name ) VALUES ( 9223372036854775807, 'Johnathan', 'Smith' );
INSERT INTO people ( first_name, last_name ) VALUES ( 'William', 'Gate' );
DROP TABLE people; CREATE TABLE people ( person_id INTEGER PRIMARY KEY AUTOINCREMENT, first_name text NOT NULL, last_name text NOT NULL );
INSERT INTO people ( person_id, first_name, last_name ) VALUES ( 9223372036854775807, 'Johnathan', 'Smith' );
INSERT INTO people ( first_name, last_name ) VALUES ( 'John', 'Smith' );
SELECT * FROM albums;
SELECT * FROM artists;
SELECT * FROM customers;
SELECT * FROM employees;
SELECT * FROM genres;
SELECT * FROM invoice_items;
SELECT * FROM invoices;
SELECT * FROM media_types;
SELECT * FROM playlist_track;
SELECT * FROM playlists;
SELECT * FROM tracks;