前提:t_book 为表名
id,title,read,comment 为表字段
查全部字段
select * from t_book
查部分字段
select t.id,t.title,t.`read`,t.`comment` FROM t_book t
增
INSERT INTO t_book VALUES (4,'西游记','1986-01-01',0,0,0)
修改
UPDATE t_book SET t_book.title ='东游记' WHERE id=4;
删除
DELETE FROM t_book WHERE title ='东游记';