MySQL Forums
Forum List  »  MySQL Shell

Error Code: 1292. Incorrect datetime value: 'null'
Posted by: Phil Siyam
Date: August 10, 2021 09:37PM

Hi,
I am getting error message : Error Code: 1292. Incorrect datetime value: 'null' when trying to insert data into table using select

Neither table has timestamp field , view_temp has timestamp values but stored in varchar field and are not part of query out put.



CREATE TABLE mdm_fms.`test_tar` ( `col_a` int DEFAULT NULL )

-- Running Query seperately

select line_no from view_temp where product_id in ('3100022', 2000000360)
Out put
10
11

Insert into mdm_fms.`test_src` (col_a)
select line_no from view_temp where product_id in ('3100022', 2000000360)

Error Code: 1292. Incorrect datetime value: 'null'

--- Works fine
Insert into mdm_fms.`test_src` (col_a)
values (10),(11)
2 row(s) affected Records: 2 Duplicates: 0 Warnings: 0

Options: ReplyQuote


Subject
Views
Written By
Posted
Error Code: 1292. Incorrect datetime value: 'null'
463
August 10, 2021 09:37PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.