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

Question

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

Answer 1

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