当前位置：首页 → 问答吧 → 球一条sql语句？

球一条sql语句？

时间：2011-12-27

来源：互联网

题目：表结构如下，从表t1中查询c_s,m_s,e_s插入表t2，但是必须t1中的school、name和t2中的school、name相同，一条sql语句实现？？？？
————————————————————
t1
school name c_s m_s e_s
一中学生一 80 80 70
二中学生一 80 90 80
一中学生二 75 80 79

t2
school name c_s m_s e_s
一中学生一
二中学生一
一中学生二

作者: qingYun1029 发布时间: 2011-12-27

SQL code

UPDATE T2 SET
  c_s = T1.c_s
  ,m_s = T1.m_s
  ,e_s = T1.e_s
FROM T1
WHERE T1.school= T2.school 
AND T1.name = T2.name

作者: Haiwer 发布时间: 2011-12-27

SQL code

update a set c_s=b.c_s,m_s=b.m_s,e_s=b.e_s from t2 a inner join t1 b on a.school=b.school and a.name=b.name

作者: qianjin036a 发布时间: 2011-12-27

SQL code

UPDATE T2 SET
  c_s = T1.c_s
  ,m_s = T1.m_s
  ,e_s = T1.e_s
FROM T1
WHERE T1.school= T2.school 
AND T1.name = T2.name

作者: Haiwer 发布时间: 2011-12-27

叫更新不叫插入

UPDATE T2 SET C_S=T1.C_S,M_S=T1.M_S... FROM T1 ,T2 WHERE T1.SCHOOL=T2.SCHOOL AND T1.NAME=T2.NAME

作者: SQL77 发布时间: 2011-12-27

SQL code

UPDATE T2 SET
  c_s = T1.c_s
  ,m_s = T1.m_s
  ,e_s = T1.e_s
FROM T1
WHERE T1.school= T2.school 
AND T1.name = T2.name

作者: Haiwer 发布时间: 2011-12-27

引用 4 楼 sql77 的回复:

叫更新不叫插入

UPDATE T2 SET C_S=T1.C_S,M_S=T1.M_S... FROM T1 ,T2 WHERE T1.SCHOOL=T2.SCHOOL AND T1.NAME=T2.NAME

对的。。。。

谢谢啦，为什么我感觉sql语句这么难写呢？？？

各式各样的语法，我汗，感觉要记忆的东西太多了。。。

有哪位大写能指点指点啊？？？

啊~~~~~~~~~~

作者: qingYun1029 发布时间: 2011-12-27

球一条sql语句？

热门阅读

热门下载