用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"
看过混子哥的半小时科学,再到半小时经济。我应该还会接着看半小时中国史等系列,不为别的。半小时动漫真的很深入浅出的用动漫的形式来给我们讲解哪些苦涩难懂的大部头专业剧集。 上下两篇分别是生活常识,金融危机。也能理解为微观经济,宏观经济。 生活常识:微观经济,主要讲述我们日常生活中所碰到的事情,例如五险一金 房产 消费陷阱 借贷 传销泡沫 金融危机:宏观经济,因为经济问题影响世界的几件大事。荷兰郁金香泡沫,英国南海泡沫,法国密西西比泡沫。美国的经济大萧条,独立战争 南北战争 一战 二战的美国发家史。