3. sql优化update表

1.考察主要是根据一张表的字段更新另一张的字段

UPDATE gmi_message_user_his_new t1
LEFT JOIN (SELECT userId,CODE,createTime FROM gmi_consumer_info  WHERE userId = '1356823')  t2
ON  t1.userId = t2.userid
AND t1.code = t2.code
SET t1.createtime = t2.createtime 
WHERE t1.userid = '1356823' 

另外根据t2表的createtime字段更新t1表的createtime字段，t1和t2表的关联方式是通过code和userid关系关联

注意：

update A left join B 

on condition1  and condition2

where condition3

其中condition3作为A表的过滤条件，condition1和condition2作为A/B表的关联关系