6.6. SQL Insert
6.6.1. Insert Values
INSERT INTO astronauts
VALUES ('Mark', 'Watney');
6.6.2. Insert Values to Columns
INSERT INTO astronauts (firstname, lastname)
VALUES ('Mark', 'Watney');
INSERT INTO astronauts (lastname, firstname)
VALUES ('Watney', 'Mark');
6.6.3. Insert to Autoincrement Column
INSERT INTO astronauts (id, firstname, lastname)
VALUES (NULL, 'Mark', 'Watney');
6.6.4. Prepared statements
For sequences (list, tuple, set):
INSERT INTO astronauts (firstname, lastname)
VALUES (?, ?);
For mappings (dict):
INSERT INTO astronauts
VALUES (NULL, :firstname, :lastname);