mysql报"ASCII\0appearedinthestatement" (2018-12-20 13:55:49)转载▼
mysql 执行sql文件时报:
ERROR :
ASCII ‘\0’ appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII ‘\0’ is expected.
解决方法:mysql --binary-mode=1 -hIP -uUSER -pPWD -PPORT
sql>use database;
sql>source /PATH/tbl.sql
PS C:\Users\Leo> mysql --binary-mode=1 -h localhost -uroot -P3306 -p