用mysql把书上代码操作了一遍，内容比较基础，实际上需要记得内容不是很多.这是一本sql的入门剧集，后面的存储过程，事务处理，游标，索引，触发器等基本等于没讲，只是了解了一下，要想深入需要补充其他知识，但是这部剧对新手很友好，学起来比较轻松
SELECT prod_name
FROM Products;
SELECT pro_names FROM Procucts;
SELECT
prod_name
FROM
Products;
SELECT prod_id,prod_name,prod_price
FROM Products;
SELECT *
FROM Products;
SELECT vend_id
FROM products;
SELECT DISTINCT vend_id
FROM products;#distinic 返回唯一值
SELECT prod_name
FROM products
LIMIT 5 OFFSET 5;
SELECT prod_name
FROM Products
ORDER BY prod_name;
SELECT prod_id,prod_price,prod_name
FROM products
ORDER BY prod_price,prod_name;
SELECT prod_id,prod_price,prod_name
FROM products
ORDER BY 2,3;
SELECT prod_id,prod_price,prod_name
FROM products
ORDER BY prod_price DESC;
SELECT prod_id,prod_price,prod_name
FROM products
ORDER BY prod_price DESC,prod_name;
SELECT prod_name,prod_price
FROM products
WHERE prod_price=3.49;
SELECT prod_name,prod_price
FROM products
WHERE prod_price<=10;
SELECT vend_id,prod_name
FROM products
WHERE vend_id <>"DLL01";
SELECT vend_id,prod_name
FROM products
WHERE vend_id!="DLL01";
SELECT prod_name,prod_price
FROM products
WHERE prod_price BETWEEN 5 AND 10;
SELECT prod_name
FROM products
WHERE prod_price IS NULL;
SELECT cust_name,cust_email
FROM customers#第一到第四节：检索，排序，过滤
SELECT prod_id,prod_price,prod_name
FROM products
WHERE vend_id="DLL01" AND prod_price<=4;
SELECT prod_name,prod_price,vend_id
FROM products
WHERE vend_id="DLL01" OR vend_id="BRS01"
ORDER BY prod_price
SELECT prod_name,prod_price
FROM products
WHERE (vend_id="DLL01"
因为大部分都是准本格，所以对我来说，可读性就没有那么高啦，但如果喜欢反转，还是推荐看一下的。 最后，最后一张的长评完全没有必要收录啊！居然把后续系列的剧情和诡计都剧透了！太过分了吧！这本还是系列的第一本！这和看推理剧集才看了五页，结果发现旁边写了一行字“第五页出现的这个男人就是凶手！”有什么区别啦
仇池流沙 · 评分 8.7/10
用mysql把书上代码操作了一遍，内容比较基础，实际上需要记得内容不是很多.这是一本sql的入门剧集，后面的存储过程，事务处理，游标，索引，触发器等基本等于没讲，只是了解了一下，要想深入需要补充其他知识，但是这部剧对新手很友好，学起来比较轻松 SELECT prod_name FROM Products; SELECT pro_names FROM Procucts; SELECT prod_name FROM Products; SELECT prod_id,prod_name,prod_price FROM Products; SELECT * FROM Products; SELECT vend_id FROM products; SELECT DISTINCT vend_id FROM products;#distinic 返回唯一值 SELECT prod_name FROM products LIMIT 5 OFFSET 5; SELECT prod_name FROM Products ORDER BY prod_name; SELECT prod_id,prod_price,prod_name FROM products ORDER BY prod_price,prod_name; SELECT prod_id,prod_price,prod_name FROM products ORDER BY 2,3; SELECT prod_id,prod_price,prod_name FROM products ORDER BY prod_price DESC; SELECT prod_id,prod_price,prod_name FROM products ORDER BY prod_price DESC,prod_name; SELECT prod_name,prod_price FROM products WHERE prod_price=3.49; SELECT prod_name,prod_price FROM products WHERE prod_price<=10; SELECT vend_id,prod_name FROM products WHERE vend_id <>"DLL01"; SELECT vend_id,prod_name FROM products WHERE vend_id!="DLL01"; SELECT prod_name,prod_price FROM products WHERE prod_price BETWEEN 5 AND 10; SELECT prod_name FROM products WHERE prod_price IS NULL; SELECT cust_name,cust_email FROM customers#第一到第四节：检索，排序，过滤 SELECT prod_id,prod_price,prod_name FROM products WHERE vend_id="DLL01" AND prod_price<=4; SELECT prod_name,prod_price,vend_id FROM products WHERE vend_id="DLL01" OR vend_id="BRS01" ORDER BY prod_price SELECT prod_name,prod_price FROM products WHERE (vend_id="DLL01"
一团印象 · 评分 1.1/10
汪老的书读起来有种浓厚的生活气息，能够很快的将读者带入故事之中，看似平淡，但却如行云流水般将故事娓娓道来，同时也展现了一丝温暖，其中，在小铜匠受伤后，各家各户都将自己家有营养的东西拿出来，展现了朴实的民风
强者 · 评分 9.8/10