1、创建表格test:
CREATE TABLE `test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`route` linestring DEFAULT NULL,
`p1` varchar(255) DEFAULT NULL,
`p2` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
2、插入两行数据:
-- ----------------------------
-- Records of test
-- ----------------------------
INSERT INTO `test` VALUES ('1', GeomFromText('LINESTRING(1 2, 2 1)'), 'p21', 'p22');
INSERT INTO `test` VALUES ('2', GeomFromText('LINESTRING(2 2, 3 1)'), 'p31', 'p32');
3、查询语句
SELECT
CONCAT(
'{
"type": "FeatureCollection",
"features": [
',
GROUP