MySQL Forums
Forum List  »  MySQL Shell

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

It worked when if set sql_mode =''

SET sql_mode = '';

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

I channged sql_mode from NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES,

to
NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES, ONLY_FULL_GROUP_BY,ERROR_FOR_DIVISION_BY_ZERO, ALLOW_INVALID_DATES

But still getting error.

I am using MySQL 8.0.23 on AWS

Options: ReplyQuote


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


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.