Follow this topic

Last answered:

18 Nov 2022

Posted on:

17 Nov 2022

0

inserting values

in SQL / UNIQUE Constraint

While inserting values in the column i get an error that Error Code 1364: Customer_id doesnt have a default value

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

18 Nov 2022

0

Hi Sebastian!
Thanks for reaching out.

You obtained the error 1364 because the column does not contain a default value and you did not provide any value in the INSERT statement.

Hope this helps.
Best,
Tsvetelin

Submit an answer

related questions

0

8

Resolved: Non null values

0

6

Will "<0" (less than zero) include null values?

1

6

Resolved: Is the minus sign to keep null values of the emp_no at the bottom?

0

2

dublicated values of column in sql

Oyindamola Oluwapelumi Okesola

0

2

WHY DOES A PRIMARY KEY HAVE DUPLICATE VALUES

0

2

SUM for columns with null values

Ayaz Mohammed Abdul Razzak

1

2

rollback poblem... unable to revert back to original data values

Osama Elsayed Mohamed

0

2

insert into department_dub (dept_name) Values ('Public Relations')