top of page
MySQL:
ST_DIFFERENCE
ST_Difference(g1, g2)
Returns a geometry that represents the point set difference of the
geometry values g1 and g2.
ST_Difference() handles its arguments as described in the introduction
to this section.
URL: https://dev.mysql.com/doc/refman/8.0/en/spatial-operator-functions.html
Example
mysql> SET @g1 = Point(1,1), @g2 = Point(2,2);
mysql> SELECT ST_AsText(ST_Difference(@g1, @g2));
+------------------------------------+
| ST_AsText(ST_Difference(@g1, @g2)) |
+------------------------------------+
| POINT(1 1) |
+------------------------------------+
bottom of page