INSERT INTO mytable VALUES ( 1,GEOMFROMTEXT('POLYGON((25 15,10 25,25 35,30 50,30 60,
35 65,40 55,45 30,55 20,25 15),(3395 2827,3861 2840,4094 2374,3395 2594,3395 2827)
)'),
GEOMFROMTEXT('LINESTRING(25 35, 45 30)'),
GEOMFROMTEXT('POINT(2850 2350)'), 'gl_1');
INSERT INTO mytable VALUES ( 2,
GEOMFROMTEXT('POLYGON((70 20,55 20,65 30,
65 50,70 55,80 50,85 40,80 30,
85 25,70 20))'),
GEOMFROMTEXT('LINESTRING(65 35, 80 30)'),
GEOMFROMTEXT('POINT(7250 2750)'), 'gl_2');
我想将POLYGON((25 15,10 25,25 35,30 50,30 60,
35 65,40 55,45 30,55 20,25 15),(3395 2827,3861 2840,4094 2374,3395 2594,3395 2827)
)和POLYGON((70 20,55 20,65 30,
65 50,70 55,80 50,85 40,80 30,
85 25,70 20)放进一个GeometryCollection里面,怎么写啊
GeometryCollectionMysql空间数据库
35 65,40 55,45 30,55 20,25 15),(3395 2827,3861 2840,4094 2374,3395 2594,3395 2827)
)'),
GEOMFROMTEXT('LINESTRING(25 35, 45 30)'),
GEOMFROMTEXT('POINT(2850 2350)'), 'gl_1');
INSERT INTO mytable VALUES ( 2,
GEOMFROMTEXT('POLYGON((70 20,55 20,65 30,
65 50,70 55,80 50,85 40,80 30,
85 25,70 20))'),
GEOMFROMTEXT('LINESTRING(65 35, 80 30)'),
GEOMFROMTEXT('POINT(7250 2750)'), 'gl_2');
我想将POLYGON((25 15,10 25,25 35,30 50,30 60,
35 65,40 55,45 30,55 20,25 15),(3395 2827,3861 2840,4094 2374,3395 2594,3395 2827)
)和POLYGON((70 20,55 20,65 30,
65 50,70 55,80 50,85 40,80 30,
85 25,70 20)放进一个GeometryCollection里面,怎么写啊
GeometryCollectionMysql空间数据库
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货