插入中文数据报错
sql> INSERT INTO mydb3
.employee
(name
, salary
, dept_id
) VALUES (‘黄紫霄’, 1000, 1)
[2020-08-21 18:11:47] [HY000][1366] Incorrect string value: ‘\xE9\xBB\x84\xE7\xB4\xAB…’ for column ‘name’ at row 1
输入如下命令,更改字符编码集
alter table employee convert to character set utf8