Error of "SQLSTATE[HY000]: General error: 1364 Field 'field_name' doesn't have a default value"

Comments (0)

Views (998)

Most of the time when we are working with MySQL we forgot to make an identification places where should be left blank and when we upload our database to server we face with error of "SQLSTATE[HY000]: General error: 1364 Field 'field_name' doesn't have a default value".

To handle this error , either you should identify a value for your column or you should say it might be a NULL.So if you run that;

ALTER TABLE `tableName` CHANGE `columnName` `columnName` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;

Here VARCHAR (255) will be whatever your column type is. Likewise, CHARACTER SET and COLLATE will change according to your database structure.

At worst, go to phpMyAdmin to edit the column and mark the Null part and save, you will get the same result :)

When you are stuck while you are coding or when you need to relax yourself comment section is waiting for you. Ask what you don't know, answer what you know !