Introduction to SQLite

SQLite basic commands

Report a typo

The following script creates a table:

CREATE TABLE Album (name text, year integer);

How do you add data to it? Select all options that will not cause an error.

Select one or more options from the list

INSERT INTO Album (name, year) VALUES ('Picnic', 2009), ('Hike', 2011);

INSERT INTO Album (name, year) VALUES ('Picnic', 2009);

INSERT INTO Album (name) VALUES ('Picnic', 2009);

INSERT INTO Album (name) VALUES ('Picnic');

___

Create a free account to access the full topic