填空题:使用delete语句删除陆以宁的购物记录,其中购物表为sale,会员表为vip,会员表中vno是会员编号 ,vname是会员名
使用delete语句删除陆以宁的购物记录,其中购物表为sale,会员表为vip,会员表中vno是会员编号 ,vname是会员名
DELETE FROM
WHERE vno
(SELECT vno FROM vip WHERE vname='陆以宁');
答案:
第1空:sale || SALE ||
第2空:IN || in ||
DELETE FROM
WHERE vno
(SELECT vno FROM vip WHERE vname='陆以宁');
答案:
第1空:sale || SALE ||
第2空:IN || in ||