批量更新和插入

tabel a 和 tabel b

将table b中的字段更新到 table a中

UPDATE way_dimes_grproll AS a INNER JOIN way_biz_customer AS b ON a.customer_id =b.customer_id
 
SET a.member_id =b.member_id,  a.user_id =b.user_id；

批量插入

INSERT INTO Table2(field1,field2,...) SELECT value1,value2,... FROM Table1