create table employee
(
id int,
name varchar(20),
gender varchar(4),
birthday date,
entry_date date,
job varchar(40),
salary double,
resume text
)character set utf8 collate utf8_general_ci;
查看插入的数据
select * from employee;
使用insert语句向表中插入一个员工的信息。
insert into employee(id,username,birthday,entry_date,job,salary,resume) values(2,'小明','1980-09-09','1980-09-09','bbb',1000,'bbbbbbbb');
插入失败后的解决方案
show variables like 'chara%';
set character_set_client=gb2312;
显示失败后的解决方案
set character_set_results=gb2312;