19,613
社区成员
发帖
与我相关
我的任务
分享
mysql --no-defaults -S /data/mysql.sock -uroot -p -bse "INSERT INTO mytest.test (id, name) VALUES ('$(printf \\x84\\xe8\\x8c\\x83)', '20')"
Enter password:
ERROR 1366 (22007) at line 1: Incorrect string value: '\x84\xE8\x8C\x83' for column 'id' at row 1
所以可能你一直用拷贝粘贴,你试着用键盘输入看看mysql --no-defaults -S /var/lib/mysql/mysql.sock -uroot -p -bse "select '测试'"
mysql --no-defaults -S /var/lib/mysql/mysql.sock -uroot -p -bse "INSERT INTO cy.test (id, name) VALUES ('规范', '20')"
如如果sock文件不在/var/lib/mysql里(多半在),就找找然后修改一下
mysql -uroot -p -bse "select '测试'"
试试
如果返回正常,再用
mysql -uroot -p -bse "INSERT INTO cy.test (id, name) VALUES ('规范', '20')"
试试