]]>re: SQL璇彞璁板綍http://www.tkk7.com/stone840/archive/2012/12/06/392154.html#392541鑰佸ぉ鑰佸ぉThu, 06 Dec 2012 05:25:00 GMThttp://www.tkk7.com/stone840/archive/2012/12/06/392154.html#392541SELECT 'update base_company set mapx='''||a.mapx||''',mapy='''||a.mapy||''' where companyid='||b.companyid||';'
FROM temp_wz_map a
LEFT JOIN base_company b ON a.custid=b.ypcustid
limit 2000;