Database data update, different tables, different databases update

xiaoxiao2021-03-06  16

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

转载请注明原文地址:https://www.9cbs.com/read-44759.html

New Post(0)