mysql
EdwardDrew
贵有恒,无需三更眠五更起;最无益,莫过一日曝十日寒
展开
-
执行sql出现 Incorrect string value: '\xF0\x9F\x8E\xB7' for column 'nickname' at row 1
[Err] 1366 - Incorrect string value: '\xF0\x9F\x8E\xB7' for column 'nickname' at row 1 报错是因为utf8不能容纳超过3个字节的emoji表情,需要使用utf8mb4字符集 解决办法: 在前面加SET NAMES utf8mb4原创 2020-05-11 21:59:22 · 830 阅读 · 0 评论 -
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
错误信息:UPDATE Role SET Desc = '管理员' WHERE Id = 11; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use nea原创 2017-08-18 15:04:39 · 1673 阅读 · 0 评论