Shulou(Shulou.com)06/01 Report--

[by way of view update]

Table An and Table B are required. You need to update the name field in Table B to the name in Table A. the two tables are associated with id. The code is as follows:

Update (select a.name aname, b.name bname from An a, B b where a.id = b.id) set aname = bname;-- Note: the associated attribute id of two tables must be unique index or primary key

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.