CODEWITHSUNDEEP
mysqlsqlmysql-error-1364
King
King

Reputation: 11

I get an error message 1364 after inserting values into table why?

INSERT INTO Werknemer (voornaam, achternaam, geboortedatum, rol, adres, stad, postcode, telefoonnummer, email, dagVanDeArbeid)
VALUES ('Kingsley', 'Ohenewaa', '2010-07-02', 'medewerker', 'Mozartlaan 70', 'Maassluis', '3144 NC', 06-91139070, '[email protected]', 'Maandag');

Error Code: 1364. Field 'Restaurant_restaurantID' doesn't have a default value 0.016 sec

Upvotes: 1

Views: 95

Answers (1)

TAM
TAM

Reputation: 1741

Sounds like you have a non-null column Restaurant_restaurantId in that table for which you didn't provide a value.

Upvotes: 2

Related Questions