排除 MySQL 技術疑難問題: Difference between revisions
Jump to navigation
Jump to search
← Older edit
Newer edit →
排除 MySQL 技術疑難問題
(edit)
Revision as of 23:55, 14 October 2024
324 bytes removed
,
14 October 2024
→Navicat error: Field doesn't have a default value
Revision as of 23:54, 14 October 2024
(
edit
)
Planetoid
(
talk
|
contribs
)
(
→如何解決 “zsh: operation not permitted: xxx.sql”
)
← Older edit
Revision as of 23:55, 14 October 2024
(
edit
)
(
undo
)
Planetoid
(
talk
|
contribs
)
(
→Navicat error: Field doesn't have a default value
)
Newer edit →
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。
== 訪問和認證錯誤 ==
== 訪問和認證錯誤 ==
Planetoid
Bureaucrats
,
Administrators
14,953
edits
Navigation menu
Personal tools
Not logged in
Talk
Contributions
Log in
Namespaces
Page
Discussion
English
Views
Read
Edit
View history
More
Search
Navigation
Main page
Current events
Recent changes
Random page
Help
Categories
Tools
Special pages
Printable version