MYSQL多表联合更新与SQL2000有所不同:
update tableA,tableB set tableA.colB= tableB.colB where tableA.colA= tableB.colA;
对应的SQL2000更新语句为:
update tableA set tableA.colB=tableB.colB from tableA,tableB where tableA.colA=tableB.colA
MYSQL多表联合更新与SQL2000有所不同:
update tableA,tableB set tableA.colB= tableB.colB where tableA.colA= tableB.colA;
对应的SQL2000更新语句为:
update tableA set tableA.colB=tableB.colB from tableA,tableB where tableA.colA=tableB.colA