5.6. SQL Insert¶
5.6.1. Insert Values¶
INSERT INTO astronauts
VALUES ('Mark', 'Watney');
5.6.2. Insert Values to Columns¶
INSERT INTO astronauts (firstname, lastname)
VALUES ('Mark', 'Watney');
INSERT INTO astronauts (lastname, firstname)
VALUES ('Watney', 'Mark');
5.6.3. Insert to Autoincrement Column¶
INSERT INTO astronauts (id, firstname, lastname)
VALUES (NULL, 'Mark', 'Watney');
5.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);