//从LINESTRING 类型提取点
select EndPoint(table1.`lines`) from table1;
//从提取的点取x值
select x(EndPoint(table1.`lines`)) from table1;
//从提取的点取x值
select y(EndPoint(table1.`lines`)) from table1;
本文共 237 字，大约阅读时间需要 1 分钟。
//从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