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;