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

Jump to navigation Jump to search
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。


== 訪問和認證錯誤 ==
== 訪問和認證錯誤 ==

Navigation menu