create table user(
	userId int not null auto_increment,
	userName varchar(50) not null,
	primary key(userId)
);

insert into user values(1,'111');
insert into user values(2,'333');
insert into user values(3,'333');

create table book(
	bookId int not null auto_increment,
	bookName varchar(50) not null,
	bookAuthor varchar(50) not null,
	bookPrice decimal(4,2) not null,
	bookInfo varchar(50) not null,
	primary key(bookId)
)default charset=gbk;

insert into book values(1,'java基础','佚名',33.44,'测试');
insert into book values(2,'java初级','佚名',33.44,'测试');
insert into book values(3,'java高级','佚名',33.44,'测试');
insert into book values(4,'java设计模式','佚名',33.44,'测试');
insert into book values(5,'java虚拟机开发','佚名',33.44,'测试');
insert into book values(6,'java架构设计','佚名',33.44,'测试');
insert into book values(7,'java性能优化','佚名',33.44,'测试');
insert into book values(8,'java web开发','佚名',33.44,'测试');
insert into book values(9,'spring MVC','佚名',33.44,'测试');
insert into book values(10,'linux','佚名',33.44,'测试');


#查看编码
show variables like '%char%';

#创建表时修改编码
default charset=gbk;

-- 查看字符编码
SHOW VARIABLES LIKE '%char%';

-- 修改数据库的字符编码
ALTER DATABASE mydb CHARACTER SET utf8;

-- 创建数据库时指定字符编码
CREATE DATABASE mydb CHARACTER SET utf8;

-- 修改数据表的字符编码
ALTER TABLE myTable DEFAULT CHARACTER SET utf8;

-- 修改表中某一列的编码
ALTER TABLE myTable CHANGE `name` `name` VARCHAR(36) CHARACTER SET utf8 NOT NULL;