update b set priceb=a.pricea from 表A a inner join 表B b on a.id=b.id
update b set PRICEB=a.PRICEA from a join b on a.id=b.id
update b set PRICEB=a.PRICEA from a , b where a.id=b.id
update b set priceb=a.pricea from 表A a inner join 表B b on a.id=b.id
update b set PRICEB=a.PRICEA from a , b where a.id=b.id
create TABLE TA ( ID VARCHAR(50), PRICEA VARCHAR(50) )create TABLE TB ( ID VARCHAR(50), PRICEB VARCHAR(50) ) INSERT INTO TA VALUES('0001','10') INSERT INTO TA VALUES('0002','20') INSERT INTO TB VALUES('0001','') INSERT INTO TB VALUES('0002','')
select TB.ID,TA.PRICEA from TB join TA on TA.ID=TB.IDID PRICEA -------------------------------------------------- -------------------------------------------------- 0001 10 0002 20(2 行受影响)
update TB set PRICEB=TA.PRICEA from TA where TA.ID=TB.ID SELECT * FROM TB ID PRICEB -------------------------------------------------- -------------------------------------------------- 0001 10 0002 20(2 行受影响)
(
ID VARCHAR(50),
PRICEA VARCHAR(50)
)create TABLE TB
(
ID VARCHAR(50),
PRICEB VARCHAR(50)
)
INSERT INTO TA VALUES('0001','10')
INSERT INTO TA VALUES('0002','20')
INSERT INTO TB VALUES('0001','')
INSERT INTO TB VALUES('0002','')
select TB.ID,TA.PRICEA from TB join TA on TA.ID=TB.IDID PRICEA
-------------------------------------------------- --------------------------------------------------
0001 10
0002 20(2 行受影响)
SELECT * FROM TB
ID PRICEB
-------------------------------------------------- --------------------------------------------------
0001 10
0002 20(2 行受影响)