14,953
edits
排除 MySQL 技術疑難問題: Difference between revisions
Jump to navigation
Jump to search
→錯誤 1305 - 函數 MY_TABLE.MY_FUNCTION 不存在
| Line 305: | Line 305: | ||
解決方案：修正函數名稱中的打字錯誤 | 解決方案：修正函數名稱中的打字錯誤 | ||
=== 錯誤 1690 - BIGINT UNSIGNED 值超出範圍 === | |||
訊息：MySQL 錯誤 #1690 (BIGINT UNSIGNED 值超出範圍) | |||
解決方案 <ref>[https://dev.mysql.com/doc/refman/8.0/en/out-of-range-and-overflow.html MySQL :: MySQL 8.0 參考手冊 :: 11.2.6 超出範圍和溢出處理]</ref><ref>[https://stackoverflow.com/questions/34115917/mysql-error-1690-bigint-unsigned-value-is-out-of-range-for-unix-timestamp MySQL 錯誤 #1690 (BIGINT UNSIGNED 值超出範圍) 用於 UNIX_TIMESTAMP() - Stack Overflow]</ref>: | |||
<pre> | |||
SET sql_mode = 'NO_UNSIGNED_SUBTRACTION'; | |||
</pre> | |||
== 資源和環境錯誤 == | == 資源和環境錯誤 == | ||