mysql学习笔记1

create table book(
   id INT NOT NULL AUTO_INCREMENT,
   book_name VARCHAR(100) NOT NULL,
   author VARCHAR(40) NOT NULL,
   publish_date DATE,
   price float,
   PRIMARY KEY (id )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into book values(1,"seleinum","wulao","2018-1-1",50);
insert into book values(2,"mysql","wulao","2018-2-1",60);
insert into book values(3,"linux","wulao","2018-3-1",80);
insert into book(book_name,author,publish_date,price) values("mangodb","zhanglao","2019-3-1",100);
insert into book(book_name,author,publish_date,price) values("bdb","zhanglao","2019-4-1",110);

select * from book;

select count(*) from book;
select book_name from book;
select book_name  as 书名 from book;
select id as 序号,book_name  as 书名 from book;
select * from book where id = 1;
select * from book where id >= 6;
select * from book where author = 'zhanglao';
select * from book where author <> 'zhanglao';
select * from book order by price asc;
select * from book order by price desc;
select count(*),author from book group by author;
select avg(price),author from book group by author;
select