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?

2

6

Values asked for both IN and OUT Parameter

0

4

INSERT INTO customers (first_name, last_name, gender, email_address, number_of_complaints) VALUES ('

Osama Elsayed Mohamed

0

2

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

Ayaz Mohammed Abdul Razzak

1

2

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

0

2

dublicated values of column in sql