Exercise: Create, Insert, Select
Create table, insert data, and select.
Solution
sql
1CREATE TABLE temp (id INTEGER, name TEXT);
2INSERT INTO temp VALUES (1, 'Test');
3SELECT * FROM temp;
Create table, insert data, and select.
1CREATE TABLE temp (id INTEGER, name TEXT);
2INSERT INTO temp VALUES (1, 'Test');
3SELECT * FROM temp;