Re: Insert to field accepted although adjusted
As you can read at
https://dev.mysql.com/doc/refman/5.7/en/out-of-range-and-overflow.html:
"If strict SQL mode is enabled, MySQL rejects the out-of-range value with an error, and the insert fails, in accordance with the SQL standard.
"If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead."
Subject
Written By
Posted
December 02, 2017 02:52AM
Re: Insert to field accepted although adjusted
December 02, 2017 11:02AM
December 02, 2017 08:06PM
Sorry, you can't reply to this topic. It has been closed.
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.