Follow this topic

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

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?

1

14

Resolved: employees.sql database not found in resources

Abdelrahman Samy

0

14

Resolved: why this code not valid

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.

3

12

sample employee Database not found as resource to be downloaded

0

12

Resolved: SELECT first_name FROM employees GROUP BY first name did not work properly

Rafael Rodrigues de Siqueira

23

12

The ROLLBACK not working according to step-by-step class

Maimuna Khatoon

0

12

Resolved: Getting Null as the result from all stored procedure queries including the assignment too.

0

10

Resolved: Why is the highlighted practice not considered a best practice?