|
2.update BB_tbl set Grade=A, Sign=B,ClassNo=C where D=“123” 1和2是先查询然后再更新表BB_tbl，1和2能否喝在一起写？怎么写？（急） |
|
|
|
|
|
update BB_tbl set Grade=a.A, Sign=a.B,ClassNo=a.C from AA_tbl a where a.c='123' and BB_tbl.D='123' and 两个表的关系
|
|
|
|
--要用单引号
update BB_tbl set Grade=(select A from AA_tbl where C='123'), Sign=(select B from AA_tbl where C='123'),ClassNo=(select C from AA_tbl where C='123') where D='123' |
|
|
|
update bb_tbl set grade=a.A,sign=b.B,classno=c.C from aa_tbl a where c='123'
and d='123' |
|
|
|
UPDATE BB_tbl LEFT JOIN AA_tbl ON BB_tbl.D=AA_tbl.D
set Grade=AA_tbl.A,Sign=AA_tbl.B,ClassNo=AA_tbl.C WHERE AA_tbl.D='123' |
|
|
关闭