pta mysql训练题集(241-260)

10-241 添加销售记录

insert into recorder
values
(null,'C008','G001',3,null),
(null,'C008','G002',1,null);

10-242 删除马齐的购物记录

delete from recorder
where cid=(select cid from customer where cname='马齐');

10-243 修改杰克的购物记录。

update recorder set quantity = 1
where cid = (
    select cid from customer where cname='杰克'
) and gid='G006';

10-244 查询单价少于500的货品信息。

select gid 商品编号,gname 商品名称,price 单价,stock 库存
from good
where price<=500
order by 商品编号 asc;

10-245 找出所有姓“张”的学生学号、姓名、院部和联系电话

select sno 学号, sname 姓名,dept