top of page
CerebroSQL

MySQL: 

ST_BUFFER_STRATEGY

ST_Buffer_Strategy(strategy[, points_per_circle])

This function returns a strategy byte string for use with ST_Buffer()
to influence buffer computation.

Information about strategies is available at Boost.org
(http://www.boost.org).

The first argument must be a string indicating a strategy option:

o For point strategies, permitted values are 'point_circle' and
'point_square'.

o For join strategies, permitted values are 'join_round' and
'join_miter'.

o For end strategies, permitted values are 'end_round' and 'end_flat'.

If the first argument is 'point_circle', 'join_round', 'join_miter', or
'end_round', the points_per_circle argument must be given as a positive
numeric value. The maximum points_per_circle value is the value of the
max_points_in_geometry system variable.

For examples, see the description of ST_Buffer().

ST_Buffer_Strategy() handles its arguments as described in the
introduction to this section, with these exceptions:

o If any argument is invalid, an ER_WRONG_ARGUMENTS
(https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference
.html#error_er_wrong_arguments) error occurs.

o If the first argument is 'point_square' or 'end_flat', the
points_per_circle argument must not be given or an ER_WRONG_ARGUMENTS
(https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference
.html#error_er_wrong_arguments) error occurs.

URL: https://dev.mysql.com/doc/refman/8.0/en/spatial-operator-functions.html

Example

bottom of page