mysql中point类型数据的操作

2022-06-13 02:20:36

point类型数据的插入

update K_User set HistoryPoint =  GeomFromText ( ‘POINT(114.72341111111112 23.289836111111114)‘ );

select ST_AsText(HistoryPoint) FROM K_User where id = 405;