mysql ASCII '\0' appeared in statement

　

appeared

• mysql 执行sql文件时报：Warning: Using a password on the command line interface can be insecure.

  ERROR at line 2104889: 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

use database;

source /PATH/tbl.sql

SQL Error: select * from ***_ecms_news where id<>'58093' and (title like '%mysql%' or title like '%ASCII%' or title like '%'%' or title like '%0%' or title like '%'%' or title like '%appeared%' or title like '%statement%') order by newstime desc limit 5