小项目实训：曹操外卖第一部分

前面的前台
1.SELECT * FROM goods WHERE goodsld
IN(SELECT goodsld FROM orderdetails WHERE orderld
IN(SELECT orederld FROM (SELECT orederld FROM orders ORDER BY orderdate DESC LIMIT 3) AS a));
/最新外卖显示/
2.SELECT a.title,a.unitprice,a.discount,a.description FROM goods a,orderdetails b WHERE a.goodsld=b.goodsld and qty=(SELECT max(qty) FROM orderdetails);
/畅销外卖显示/
3.SELECT *FROM goods WHERE discount<‘1‘;
/活动外卖显示/
4.SELECT *FROM goods WHERE title=‘辣菜‘ AND description LIKE ‘%辣%‘;
/按照某个关键字鱼外卖标题的匹配查询外卖信息并显示/
5.SELECT *FROM goods GROUP BY title;
/按照外卖类别分类显示外卖信息/
6.SELECT *FROM goods WHERE goodsld=‘1‘;
/用户点击某一个外卖，显示该外卖的详细信息/
7.UPDATE goods SET xiadingdan=‘1‘ WHERE title=‘汉堡‘;
/用户可以选择自己喜欢的外卖，放入购物车（显示1为加入成功）/
8.SELECT *FROM customers WHERE longinpwd=‘tom_love$book‘ AND EXISTS(SELECT zhuangtai FROM customers WHERE custname=‘亢磊涛‘);
/用户如果需要登录，需要先注册为本网站的用户/
9.SELECT zhuangtai FROM customers WHERE longinpwd=‘tom_love$book‘ AND EXISTS (SELECT zhuangtai FROM customers WHERE custname=‘兔兔‘);
/用户可以对购物车中的外卖下订单，下订单前需先登录/
10.SELECT invoicecontent FROM orders WHERE custname=‘兔兔‘;
/用户登录后可以查询自己的订单的情况，包括是否发货、商品在途情况、商品签收情况/
INSERT customers VALUES (‘tom‘,‘123456‘,‘010-60257566‘,‘tom@hotmail.com‘,‘北京市海淀区苏州街18号威亚大厦12楼‘);

小项目实训：曹操外卖第一部分

原文：https://www.cnblogs.com/zhe1314/p/11632175.html