用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"
基本不看电视的我,特别是电视剧的人,看了这本就像追了一部青春偶像剧,很解压,很轻松,就跟着这简单的故事,一路下来了,暖暖的!喜欢这些人充满正能量的三观,喜欢年轻人对于处理亲情,爱情以及人情世故的方法,喜欢现代人对于工作和生活的平衡理解,喜欢这暖暖的故事,这里的每个人:彭正廷,林烟,简糯,高深,陈硕,闫心悦,悠悠,小余……都是我想要喜欢的人,读完这部剧也像和这些人成了朋友一样。真好!
什么“会遇上对的人”,男人一生的挚爱只有一次,他为她燃尽所有,剩下来的就是灰烬。后来的傻女人不过就是一边流泪流血为他付出,还想着从灰烬里找出点什么。灰烬就是灰烬,除了蹭你一身灰,把你弄得肮脏狼狈还能期待什么。醒醒吧,对自己好点才是最重要的
看完这部剧,就一个感觉,画画重要的不是技术,而是她所表达的意思 情感和想法,只要饱含情感就行
感觉编剧有点编不下去了,赶紧结尾算了,也没什么新鲜的出炉了。