排除 MySQL 技術疑難問題: Difference between revisions

排除 MySQL 技術疑難問題 (edit)

564 bytes removed , 14 October 2024

14,953

edits

@@ Line 444: / Line 444: @@
 * [http://stackoverflow.com/questions/5696857/how-to-change-value-for-innodb-buffer-pool-size-in-mysql-on-mac-os innodb - 如何在 Mac OS 上改變 MySQL 的 innodb_buffer_pool_size 的值？ - Stack Overflow]。
 * [https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html MySQL :: MySQL 5.7 參考手冊 :: 14.6.3.2 配置 InnoDB 緩衝池大小]
-== 錯誤 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>
 == 錯誤 2002: 無法連接: SQLSTATE[HY000] [2002] ==