1: Update of the same database: Data column1 update table B data Column1 method UPDATE table bset column1 = a.column1 from table a a A, table bwhere a. Association = b. Association
2: Different database updates: Database A, table A of Table A update database B, table B of Table B. COLUMN1 UPDATE Database B. Table Bset B.Column1 = a.column1 from water..wq_stinfo_b A, Watersjsgnq. .Wq_stinfo_b bwhere a.column1 = b.column1