A9925的专栏

转载 查询结果update字段到另外一张表中

http://www.jb51.net/article/71790.htm UPDATE t_advs_order a INNER JOIN tk_zyt_scenery_order s ON s.order_id=a.`on` SET a.attribute1=s.order_id, a.attribute2=s.order_id; UPDATE