＜＜MySQL数据库基础与实践＞＞P102 操作题

(1) 

SELECT * FROM bookinfo WHERE B_Name LIKE 'C#%'

(2) 

SELECT B_Publisher FROM bookinfo WHERE '清华大学出版社' GROUP BY B_Date > '2004-01-01';

(3) 

SELECT * FROM bookinfo ORDER BY B_MarketPrice DESC,B_Date ASC

 (4) 

SELECT SUM(O_TotalPrice),O_UserName FROM orders GROUP BY O_UserName

 

(5) 

SELECT * FROM orderdetails ORDER BY OD_Number*OD_Price DESC
 
SELECT OD_Number*OD_Price AS '每天的订单总额',OD_ID FROM orderdetails GROUP BY OD_ID;SELECT * FROM orderdetails ORDER BY OD_Number*OD_Price DESC

 

 (6)

SELECT * FROM orders WHERE O_UserName LIKE 'lijuan'

(7) 

SELECT * FROM orders WHERE O_UserName LIKE '林丽';

UPDATE `orders` SET O_Status='2' WHERE O_UserName='林丽'