How to solve to ERROR: Could not able to execute INSERT INTO saveanswer (answer) VALUES ('d'). Field 'sanswer' doesn't have a default value

Question

ERROR: Could not able to execute INSERT INTO saveanswer (answer) VALUES ('d'). Field 'sanswer' doesn't have a default value

Providing the value for `sanswer` will solve your error. It is declared `not null` (it is probably your primary key) and not autoincrement, so you have to set the value (or use autoincrement or a default value). — Solarflare, Sep 16 '16 at 10:58
Possible duplicate of [mysql error 1364 Field doesn't have a default values](http://stackoverflow.com/questions/15438840/mysql-error-1364-field-doesnt-have-a-default-values) — Alex Andrei, Sep 16 '16 at 11:02

score 0 · Answer 1 · answered Sep 16 '16 at 11:09

One option will be to specify a value for that field in the query like this:

INSERT INTO saveanswer (answer, sanswer) VALUES ('d', 'something here')

Other solution will be to alter your table to set a default value for that field (null or something else) like this:

ALTER TABLE saveanswer ALTER COLUMN sanswer SET DEFAULT null;

1 Answers1