CREATE DATABASE books CHARSET=utf8; USE books; CREATE TABLE book( id INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(50) NOT NULL, author VARCHAR(30) NOT NULL, publication VARCHAR(50), price FLOAT, COMMENT TEXT ); INSERT INTO book (title,author,publication,price,COMMENT) VALUES ("边城","沈从文","机械工业出版社",36,'小城故事多'), ("骆驼祥子","老舍","中国教育出版社",43,'你是祥子吗'), ("茶馆","老舍","中国文学出版社",55,'老北京'), ("呐喊","鲁迅","中国教育出版社",72.5,'最后的声音'), ("围城","钱钟书","中国文学出版社",54,'你心中的围城是什么'); INSERT INTO book ( title, author, publication, price ) VALUES ( "林家埔子", "矛盾", "机械工业出版社", 66 ), ( "朝花夕拾", "鲁迅", "中国文学出版社", 55 ) ; SELECT * FROM book;
#查找30多元的 SELECT * FROM book WHERE price>=30 AND price<40; #查找中国教育出版社的 SELECT * FROM book WHERE publication="中国教育出版社"; #查找老舍写的,中国文学出版社的 SELECT * FROM book WHERE author = "老舍" AND publication="中国文学出版社"; #查找备注不为空的 SELECT * FROM book WHERE COMMENT IS NOT NULL; #查找价格超过60的,只看书名和价格 SELECT title,price FROM book WHERE price>60; #查找鲁迅写的或者矛盾写的 SELECT * FROM book WHERE author="鲁迅" OR author="茅盾";