Sql error while inserting data into database

I am using Mysql server as a database to insert the data through Database writer. I have 20 field in my table . But i am going to insert 3 filed only. During insertion i got an issue :



"Wrapped java.sql.SQLException: Field 'table_field' doesn't have a default value"



Insert query only created this. Update not.



I have tried to get the solution via google surfing. i could't get the results.



Can anyone help me to solve this problem?



Thanks in advance.

Sql error while inserting data into database