用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"
REVIEWS
“波伏瓦没有夸大女人应有的作用,而是一一摆出女人在人类历史上所遭遇的悲剧命运,最鲜明而又最有说服力地展示了女人的处境。波伏瓦超出一般的女权主义者之处,体现在她辩证地理解女人的特点和应有的作用,而不是仅仅气势汹汹地发出不平之鸣。”
看前面觉得,哎,只有14集。
用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"