2020年4月28日
sqlserver读取插入空间数据
摘要： select (t.shape.STAsText()) as shape,t.id from geotest t order by 1 offset 0 rows fetch next 10 rows only INSERT INTO geotest(shape) VALUES (geometry: 阅读全文
posted @ 2020-04-28 18:20 leechg 阅读(341) 评论(0) 推荐(0)
mysql 插入 查询 空间数据
摘要： select st_astext(line) from geotest; INSERT INTO geotest (line) VALUES(GeomFromText('LINESTRING(0 0,1 1,2 2,3 3)')); SET @g2 = 'POLYGON((0 0,3 0,3 3,0 阅读全文
posted @ 2020-04-28 18:15 leechg 阅读(514) 评论(0) 推荐(0)