CREATE INSERT SELECT

• CREATE
• INSERT
• SELECT

CREATE TABLE person (
    name TEXT,
    email TEXT
);

INSERT INTO person (name, email) VALUES ('Foo', 'foo@example.com');
INSERT INTO person (name, email) VALUES ('Bar', 'bar@example.com');
SELECT * from person;

• In memory:

$ sqlite3 < create-insert-select.sql
Foo|foo@example.com
Bar|bar@example.com

• In file:

$ sqlite3 demo.db < create-insert-select.sql
Foo|foo@example.com
Bar|bar@example.com

$ rm -f demo.db