14,954
edits
排除 MySQL 技術疑難問題: Difference between revisions
Jump to navigation
Jump to search
→錯誤 1070 (42000): 指定的鍵太長；最大鍵長為 767 位元組
| Line 184: | Line 184: | ||
ALTER TABLE `table_name` ROW_FORMAT=COMPRESSED; | ALTER TABLE `table_name` ROW_FORMAT=COMPRESSED; | ||
</pre> | </pre> | ||
=== Navicat error: Field doesn't have a default value === | |||
錯誤： | |||
<pre> | |||
[ERR] 1364 - Field 'source' doesn't have a default value | |||
</pre> | |||
解決方案： | |||
* 從 Excel 匯入到資料庫時，source 欄位是空值或者沒有指定，需要指定 source 欄位值。或者修改欄位定義，允許欄位值可以 NULL。 | |||
== 資源和環境錯誤 == | == 資源和環境錯誤 == | ||