Larael Multiple Data Insert Error
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column 'unit_id' at row 2 (SQL: insert into
product_prices
(created_at
,product_id
,unit_id
,updated_at
) values (2016-12-06 06:56:01, 27, 1,2016-12-06 06:56:01), (2016-12-06 06:56:01,27, , 2016-12-06 06:56:01))
But my unit_id
field in nullable();
Please someone help me
Here column_name=unit_id
null is different than not existend. If you want to set null as a value you have to write it in your query:
... ('2016-12-06 06:56:01',27, null, '2016-12-06 06:56:01'))
Also the datetime format is wrong. You have to enter it as a string.