用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"
观众评论
一本读的很艰难的书，一方面可能与编剧的写作风格有关系，也和译者翻译有关系。六十年前成功预测了当今的互联网社会以及机器人自动化时代，因为媒介和环境的改变，人越来越重新部落化，对人的要求不再是切割的机械的专业的，而是统一连续全面的了。 这部剧讨论的远远超过“媒介即信息”以及“技术是人的延伸”，但这两句是编剧的思想精髓所在。
哦还有李玖哲哥
感谢在我感情最迷茫的时候遇见了这部剧，人生匆匆几十年，不要为了一个不值得的人而浪费生命，放手才是我最好的解脱，付出的十年光阴就当是一次教训，努力做自己的太阳，
用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"
别人怎么对你， 都是你教的。 每一个出现在你生命中的人， 都是有原因的。 爱你的人，给了你温暖； 伤你的人，给了你历练。 那些伤害你的人， 还有欺骗你的人， 其实是来渡你的。 他们渡了你，教会你， 也成就了更好的你！ 余生，好好爱自己， 活成自己喜欢的模样！ 改善人际关系， 调整人生模式， 活出全新的自己！