15,039
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
→ERROR 1690 - BIGINT UNSIGNED value is out of range
| Line 219: | Line 219: | ||
Message: MySQL error #1690 (BIGINT UNSIGNED value is out of range) | Message: MySQL error #1690 (BIGINT UNSIGNED value is out of range) | ||
Solution <ref>[https://stackoverflow.com/questions/34115917/mysql-error-1690-bigint-unsigned-value-is-out-of-range-for-unix-timestamp MySQL error #1690 (BIGINT UNSIGNED value is out of range) for UNIX_TIMESTAMP() - Stack Overflow]</ref>: | Solution <ref>[https://dev.mysql.com/doc/refman/8.0/en/out-of-range-and-overflow.html MySQL :: MySQL 8.0 Reference Manual :: 11.2.6 Out-of-Range and Overflow Handling]</ref><ref>[https://stackoverflow.com/questions/34115917/mysql-error-1690-bigint-unsigned-value-is-out-of-range-for-unix-timestamp MySQL error #1690 (BIGINT UNSIGNED value is out of range) for UNIX_TIMESTAMP() - Stack Overflow]</ref>: | ||
<pre> | <pre> | ||
SET sql_mode = 'NO_UNSIGNED_SUBTRACTION'; | SET sql_mode = 'NO_UNSIGNED_SUBTRACTION'; | ||