I’m getting Error #1064 when i try to insert a record with 0 in a decimal field (the field name is “estimation”) into my table.
This is my query:
insert into needs(id_org,date_created,date_required,place_required,description,contact,phone,email, remarks, cur_id,estimation,user_id)
values(2,'2011-01-31','2011-02-07','Place','test','Tom Jones','111-1234','','test',,0,2)
This query works if the ‘estimation’ field has any other value except 0.
Note that ‘estimation’ is set to DECIMAL(10,2)
Can anyone assist??