Back to Github repository
Clear
Reset
Execute
Save
Load File
SELECT 1e999, -1e999, 1e308, 1308, true, false, null, 'hi', x'123456'; DROP TABLE IF EXISTS person; CREATE TABLE person ( personId INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL, description VARCHAR(2048) NOT NULL, bio VARCHAR(9001) NOT NULL AS ('Hi, my name is ' || name || '. ' || description) ); INSERT INTO person (name, description) VALUES ('Tom', 'I love to change lightbulbs'), ('Dick', 'I love lightbulbs'), ('Harry', 'I lightbulbs') ; SELECT * FROM person; pragma table_info(person); SELECT * FROM sqlite_master;