Gilliane Pornasdoro
Last answered:

09 Nov 2022

 Posted on:

05 Nov 2022
1

Resolved: why in 2:36 there's no NOT NULL in purchase_ID ?

in SQL / PRIMARY KEY constraint

aren't primary supposed to not have NULL values?

1 answers ( 1 marked as helpful)
Tsvetelin Tsonkov
Instructor
Posted on:

09 Nov 2022
0

Hi Gilliane!
Thanks for reaching out.

By default primary keys are NOT NULL, so there is no need to use this constraint.

Hope this helps.
Best,
Tsvetelin

Helpful answer

Submit an answer

related questions

Rhys Morgan
3
28
Rollback not reverting DB state after using INSERT INTO
Marcus Wern Han Leong
2
16
Why did you not do not null, primary key and auto increment for customer id in the solution?
Joseph Skvarna
1
14
Resolved: employees.sql database not found in resources
Abdelrahman Samy
0
14
Resolved: why this code not valid
Tara Gholston
0
12
Resolved: MySQL set up a connection not working?
Mohamed AbdulHalim
0
12
Resolved: Playing the text in the video does not work, although I have cc enabled, what is the solution please
Lizeth Alexandra Estevez Joya
0
12
The schema section does not show the tables in the Tables subsection.
Bader Alsahli
3
12
sample employee Database not found as resource to be downloaded