Introduction
Default values
How to auto-generate values in a database
Instruction
Okay. Now let's use a query to insert data in a table with a SERIAL column.
In the author table, suppose that we've added SERIAL as the PRIMARY KEY to the id column. Let's insert a new record:
INSERT INTO author (first_name, last_name, photo) VALUES
('Evo', 'Black', 'imgs/black2.jpg');
This is the result of that INSERT operation:
| id | first_name | last_name | photo | create_timestamp | is_active |
|---|---|---|---|---|---|
| 10 | Evo | Black | imgs/black2.jpg | {current timestamp} | false |
Notice that you have to omit the id column with SERIAL; its value will be auto-generated. Also, if we insert the first record into the table, the id will be 1. If there are other records in the table, SERIAL will be whatever the next value is. In this case, we had 9 other records before we inserted this one, so this row gets an id of 10.
Exercise
Add the next new author to the database. You only know her name, Sally Adams, and that her account is active.
