Creating Tables in SQL

31/36 DEFAULT - Sequences #2

1. Constraints - Introduction

2. UNIQUE - Introduction

3. UNIQUE - Adding new rows

4. UNIQUE - Adding rows with the same value

5. UNIQUE vs. PRIMARY KEY

6. UNIQUE - Playing around

7. UNIQUE on multiple columns

8. UNIQUE on multiple columns - Playing around

9. Multiple UNIQUE constraints

10. NOT NULL - Introduction

11. NOT NULL - Adding NULL values

12. NOT NULL - Creating tables

13. NOT NULL - default behavior

14. NOT NULL - default behavior continued

15. NULL columns

16. NULL or NOT NULL?

17. NULL in ERD diagrams

18. CHECK - Introduction

19. CHECK - adding new values

20. CHECK - updating rows

21. CHECK - creating tables

22. CHECK - complex conditions

23. CHECK - conditions using a few columns

24. CHECK - updating rows with complex contraints

25. CHECK - practice

26. DEFAULT - Introduction

27. DEFAULT - Inserting data

28. DEFAULT - NULL values

29. DEFAULT - Creating tables

30. DEFAULT - Sequences

31. DEFAULT - Sequences #2

32. DEFAULT - Sequences #3

Good, the first step is behind us. Let's proceed.

Just to remind you: in order to get the next value of the sequence my_sequence, we use the expression:

nextval('my_sequence')

Now, change the template we provided. We don't want the DEFAULT value of id to be 1. Replace it with the next value of the sequence id_seq.

Instruction

Exercise

Need assistance?

login:
password:
Remember me on this computer

Recipient's Name:
Recipient's Email:
Your Message (Optional):

Create a free accountand start learning now!

What you get?

Sign upand join a company account!

Log in

Your registration has been successfully finished

Wrap course as a gift

Instruction

Exercise

Need assistance?