14,953
edits
排除 MySQL 技術疑難問題: Difference between revisions
Jump to navigation
Jump to search
→錯誤！：SQLSTATE[HY000]：一般錯誤
| Line 273: | Line 273: | ||
* "您不應該在 update 或 insert 查詢中使用 {{kbd | key=<nowiki>$result = $stmt->fetchAll();</nowiki>}}" <ref>[https://stackoverflow.com/questions/12979510/pdo-error-sqlstatehy000-general-error-when-updating-database php - PDO error: " SQLSTATE[HY000]: General error " When updating database - Stack Overflow]</ref>。 | * "您不應該在 update 或 insert 查詢中使用 {{kbd | key=<nowiki>$result = $stmt->fetchAll();</nowiki>}}" <ref>[https://stackoverflow.com/questions/12979510/pdo-error-sqlstatehy000-general-error-when-updating-database php - PDO error: " SQLSTATE[HY000]: General error " When updating database - Stack Overflow]</ref>。 | ||
* 您不應該在查詢 {{kbd | key=<nowiki>INTO OUTFILE ...</nowiki>}} 中使用 {{kbd | key=<nowiki>$result = $stmt->fetchAll();</nowiki>}} <ref>[http://www.tech-recipes.com/rx/1475/save-mysql-query-results-into-a-text-or-csv-file/ Save MySQL query results into a text or CSV file]</ref><ref>[https://stackoverflow.com/questions/13369164/cant-create-write-to-file-errcode-22 mysql - Can't create/write to file (Errcode: 22) - Stack Overflow]</ref>。 | * 您不應該在查詢 {{kbd | key=<nowiki>INTO OUTFILE ...</nowiki>}} 中使用 {{kbd | key=<nowiki>$result = $stmt->fetchAll();</nowiki>}} <ref>[http://www.tech-recipes.com/rx/1475/save-mysql-query-results-into-a-text-or-csv-file/ Save MySQL query results into a text or CSV file]</ref><ref>[https://stackoverflow.com/questions/13369164/cant-create-write-to-file-errcode-22 mysql - Can't create/write to file (Errcode: 22) - Stack Overflow]</ref>。 | ||
=== 錯誤：ASCII '\0' 出現在語句中，但這是不允許的，除非啟用了 --binary-mode 選項並且 mysql 以非互動模式運行 === | |||
訊息：{{kbd | key=<nowiki>錯誤：ASCII '\0' 出現在語句中，但這是不允許的，除非啟用了 --binary-mode 選項並且 mysql 以非互動模式運行。如果期望 ASCII '\0'，請將 --binary-mode 設為 1。查詢：''。</nowiki>}} | |||
狀況：當我導入 sql 文件時遇到上述錯誤訊息。 | |||
解決方案：解壓縮文件然後再次導入文件<ref>[https://stackoverflow.com/questions/17158367/enable-binary-mode-while-restoring-a-database-from-an-sql-dump mysql - Enable binary mode while restoring a Database from an SQL dump - Stack Overflow]</ref>。sql 文件是壓縮文件。您可以使用 [https://en.wikipedia.org/wiki/File_(command) file (command)] 來識別文件的類型。 | |||
<pre> | |||
$ file compressed.sql | |||
compressed.sql：gzip 壓縮數據 | |||
$ file plain_text.sql | |||
plain_text.sql：UTF-8 Unicode 文本，帶有非常長的行 | |||
</pre> | |||
== 資源和環境錯誤 == | == 資源和環境錯誤 == | ||