利用拼接字符串转换point
select GeomFromText(CONCAT('POINT(',lng,' ',lat,')')) from community limit 1;
插入字段到新表
create table communityN as select *,GeomFromText(CONCAT('POINT(',lng,' ',lat,')')) location from community;
利用拼接字符串转换point
select GeomFromText(CONCAT('POINT(',lng,' ',lat,')')) from community limit 1;
插入字段到新表
create table communityN as select *,GeomFromText(CONCAT('POINT(',lng,' ',lat,')')) location from community;