MySQL

MySQL

Field Doesn't Have a Default Value And sql-mode On MySQL

MySQL doesn't allow us to set default value for field with TEXT data type. It caused MySQL often return error message "Field '' doesn't have a default value". And it occur because we do not set value for that field when execute SQL statement, while that field has no default value.

Syndicate content