Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
m
→Navicat error: Import data mismatch
Tags: Mobile edit Mobile web edit |
Tags: Mobile edit Mobile web edit |
||
| Line 547: | Line 547: | ||
Solution: | Solution: | ||
* [https://errerrors.blogspot.com/2023/11/blog-post.html 解決 NaviCat 匯入 Excel 檔案到資料庫，出現資料總筆數不一致的問題] (written in Mandarin) | * [https://errerrors.blogspot.com/2023/11/blog-post.html 解決 NaviCat 匯入 Excel 檔案到資料庫，出現資料總筆數不一致的問題] (written in Mandarin) | ||
== Navicat error: Field have a default value == | |||
<pre> | |||
[ERR] 1364 - Field 'source' doesn't have a default value | |||
</pre> | |||
Solution: | |||
* When importing from Excel to a database, if the 'source' field is empty or not specified, it's necessary to assign a value to the 'source' field. Alternatively, modify the field definition to allow the field value to be NULL. | |||
== PHP Fatal Error: Allowed Memory Size Exhausted when import SQL.GZ file using adminer == | == PHP Fatal Error: Allowed Memory Size Exhausted when import SQL.GZ file using adminer == | ||