show databases;

use master;

show tables;

drop table book;

create table book(

bid int not null auto_increment primary key,

bname varchar(50),

bauthor varchar(50),

price decimal(10,2),

bpress varchar(50),

phone varchar(11)

);

desc book;

select * from book;

insert into book values(null,'老人与海','海明威',12.5,'人民文学出版社','15816881688');

insert into book values(null,'阿Q正传','鲁迅',15.5,'当当','15816881688');

insert into book values(null,'警察手记','伊红志',22.1,'北京联合出版公司','15816881688');

insert into book values(null,'蜀山剑侠传','还珠楼主',238.7,'花山文艺出版社','15816881688');

insert into book values(null,'安娜-卡列宁娜','托尔斯泰',60.7,'西安交通大学出版社','15816881688');

insert into book values(null,'童年','高尔基',18.8,'西安交通大学出版社','15816881688');

insert into book values(null,'神秘岛','儒勒凡尔纳',24.5,'作家出版社','15816881688');

insert into book values(null,'活着','余华',28.8,'人民文学出版社','15816881688');

insert into book values(null,'兄弟','余华',34.5,'人民文学出版社','15816881688');

insert into book values(null,'蛙','莫言',22.6,'人民文学出版社','15816881688');