用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"
关于商战的一本剧,但是台词真的没有什么亮点,看了不到一半就看不下去了,也许是我没有get到里面的点吧!
权倾朝野的张居正,人上人的万历皇帝,一团和气首辅申时行,廉洁不阿的海瑞,天才将领戚继光还有思想矛盾的李贽。这群人生活于万历年间,或多或少他们在那个时代都有着改变时局的大小能力,然而,最后却都逃不开社会形态的限制,被时代狠狠的摁倒。有时候不禁为他们唏嘘,同时也在思考这样一个问题,思想被时代所限制,人力真的在社会形态面前毫无抵抗力,那是否是要学着万历皇帝一般躺平接受时代的淘汰?还是学着张居正,李贽一般即使名裂身败也去试?也许不管如何选择,历史滚动的浪潮最终还是会把所有选择都淹没,留下来的也只是作为后人评判研究的材料罢了。
有良心有血性的人在这种国家机器里是很难被包容的。 尔虞我诈君臣互相演戏试探掌控人心,是很扭曲人性的。
我看到了霍金不断追求真理,不断打破自己的认知和理论,科学求真的态度和方法,同时客观地谈论宗教和上帝,最终引导读者思考并建立科学的世界观。