2019独角兽企业重金招聘Python工程师标准>>>
//从LINESTRING 类型提取点
select EndPoint(table1.`lines`) from table1;
//从提取的点取x值
select x(EndPoint(table1.`lines`)) from table1;
//从提取的点取x值
select y(EndPoint(table1.`lines`)) from table1;
2019独角兽企业重金招聘Python工程师标准>>>
//从LINESTRING 类型提取点
select EndPoint(table1.`lines`) from table1;
//从提取的点取x值
select x(EndPoint(table1.`lines`)) from table1;
//从提取的点取x值
select y(EndPoint(table1.`lines`)) from table1;
转载于:https://my.oschina.net/jingshishengxu/blog/1613113