sql语句

2013-06-19  张瑞刚 

以下三张表
  student(id,sex,gender,age)
  subject(sid,name)
  score(id sid score)

select a.id,score from a,b where a.id=b.id and age>18
update socre set score='score+10' where id in(select id from age>18)

delete from socroe WHERE `id` IN (SELECT `id` FROM sutudent WHERE `age` > 18) AND `cid` IN (SELECT `cid` FROM `score` WHERE `name`='x')
314°/3148 人阅读/0 条评论 发表评论

登录 后发表评论