mysql中point类型数据的操作
point类型数据的插入
update K_User set HistoryPoint = GeomFromText ( 'POINT(114.72341111111112 23.289836111111114)' );
point类型数据的查询
select ST_AsText(HistoryPoint) FROM K_User where id = 405;
update K_User set HistoryPoint = GeomFromText ( 'POINT(114.72341111111112 23.289836111111114)' );
select ST_AsText(HistoryPoint) FROM K_User where id = 405;