-- 创建表 书籍表
CREATE TABLE t_book(
	id INT,
	name VARCHAR(30),
	author VARCHAR(10),
	price DOUBLE
)

select * from t_book;

insert into t_book(id, name, author, price) values (1, "项目驱动零起点学java", "马士兵、赵珊珊", 69.8);
insert into t_book(id, name, author, price) values (2, "活着", "余华", 45);

DELETE FROM t_book WHERE id=2;

UPDATE t_book set price=36.6 WHERE id=1;

SELECT name, author FROM t_book;
SELECT * FROM t_book WHERE price > 40;