Back to SQL Errors
SQL Error

1364

Field doesn't have a default value

What does this error mean?

Trying to insert a row without providing value for a NOT NULL column that has no default.

How to fix 1364?

Provide a value for all NOT NULL columns. Add DEFAULT value to column definition. Use NULL if column allows it.

Related SQL Errors