mysql测试数据

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;