#1067 - Invalid default value for 'bonusid' how can i fix this error?

Question

SQL query:

CREATE TABLE bonus(
bonusid INT( 10 ) DEFAULT  '0' NOT NULL AUTO_INCREMENT ,
empid INT( 10 ) DEFAULT  '0' NOT NULL ,
datebonus DATE DEFAULT  '0000-00-00' NOT NULL ,
bonuspayment VARCHAR( 200 ) NOT NULL ,
note TEXT NOT NULL ,
PRIMARY KEY ( bonusid )
);

MySQL said: Documentation

1067 - Invalid default value for 'bonusid'

Solution

You don't have to give default value for a primary key with auto increment value. Since you have defined bonusid as a primary key and has defined auto increment.So this will automatically create a new value for bonusid whenever a new record is inserted.So try like this

CREATE TABLE bonus(
   bonusid INT( 10 ) NOT NULL AUTO_INCREMENT ,
   empid INT( 10 ) DEFAULT  '0' NOT NULL ,
   datebonus DATE DEFAULT  '0000-00-00' NOT NULL ,
   bonuspayment VARCHAR( 200 ) NOT NULL ,
   note TEXT NOT NULL ,
   PRIMARY KEY ( bonusid )
);