Pages

Sunday, 14 June 2015

MySQL : field doesn't have a default value in MySql when inserting values into a table


On the command prompt issue below command then try inserting the values.

mysql> set @@sql_mode = '  ';
Query OK, 0 rows affected (0.00 sec)

Example :
mysql> INSERT INTO nb (id) VALUES(3);
Query OK, 1 row affected, 1 warning (0.00 sec)

References:
https://netbeans.org/bugzilla/show_bug.cgi?id=190731

No comments:

Post a Comment