Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

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