#SELECT substring_index(coordinate,',', 1), substring_index(coordinate,',', -1) FROM tmp a LEFT JOIN table b on a.uid = b.uid WHERE;
UPDATE tmp a LEFT JOIN table b on a.uid = b.uid SET b.lgt = substring_index(a.coordinate,',', -1), b.lat=substring_index(a.coordinate,',', 1);
UPDATE tmp a LEFT JOIN table b on a.uid = b.uid SET b.lgt = substring_index(a.coordinate,',', -1), b.lat=substring_index(a.coordinate,',', 1);