Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Data Types in SQL

Introduction
Identity columns
Sequences
Summary

Instruction

Good job! You can see that GENERATED ALWAYS AS IDENTITY added after a column type auto-generates integers for you.

Exercise

Add a few more rows to the table and see for yourself how the consecutive numbers are generated for the column id. Insert rows using the Run and check code button. As you can see, new values are generated automatically.

When you're done with the exercise, click I'm done. Next exercise.

Stuck? Here's a hint!

To insert more rows, use:

INSERT INTO movie (title, year, genre) VALUES
( ... ),
( ... ),
( ... );