mysql项目练习_mysql练习项目

SELECT * FROM `category`

//最新外卖显示

SELECT max(Goodsld)FROM goods ;

SELECT * FROM goods WHERE Goodsld in (SELECT max(Goodsld)FROM goods);

//畅销外卖显示

SELECT Goodsid FROM orderdetails WHERE qty in(SELECT MAX(qty) FROM orderdetails);

SELECT * FROM goods WHERE Goodsld in (SELECT Goodsid FROM orderdetails WHERE qty in(SELECT MAX(qty) FROM orderdetails));

//活动外卖显示

SELECT Goodsld FROM goods WHERE Discount<1;

SELECT * FROM goods WHERE Goodsld in (SELECT Goodsld FROM goods WHERE Discount<1);

//按照某关键字与外卖标题的匹配查询外卖信息并显示

SELECT * FROM goods WHERE Title like '黑%';

//按照外卖类别分类显示外卖信息

SELECT * FROM goods a,category b WHERE a.Cateid=b.catelid and Cateid=1;

//用户点击一个外卖，显示该外卖的详细信息

SELECT * FROM goods WHERE Goodsld=3;

//用户可以选择自己喜欢的外卖，放入购物车 喜欢为1 默认为0

SELECT * FROM goods WHERE xihaun=1;

//用户可以对购物车中的外卖下订单，下订单钱需先登录

SELECT a.CustName,a.LoginPwd FROM customers a ,orderdetails b WHERE a.Custid=b.Order and a.CustName='黄雅玲' and a.LoginPwd='666666';

//用户登录后可以查询自己的订单的情况，包括是否发货、商品在途情况、商品签收情况

SELECT * FROM orders WHERE Custld IN (SELECT Custid FROM customers WHERE CustName='黄雅玲' and LoginPwd='666666' );

//外卖基本信息录入

INSERT goods

VALUES('29','热干面','6','1','3