创建表格students,
create table students (name varchar(255),subject varchar(255),score int,stuid int);
添加数据,
insert into students values ('张三','数学',89,1),('张三','语文',80,1),('张三','英语',70,1),('李四','数学',90,2),('李四','语文',70,2),('李四','英语',80,2);
因为有中文存在,报错:ERROR 1366 (HY000): Incorrect string value: '\xE5\xBC\xA0\xE4\xB8\x89' for column 'name' at row 1
修改中文列的编码格式:
alter table students change name name varchar(255) character set utf8;
alter table students change subject subject varchar(255) character set utf8;
重新执行添加语句,添加成功。