mysql存储过程查询结果为空_MySQL存储过程，如果存储过程的结果集为空，则更改一个变量并再次运行。...

DROP PROCEDURE `getCercanoRadio`//

CREATE DEFINER=`prog2sc`@`localhost`

PROCEDURE `getCercanoRadio`

(IN latitude Double, IN longitude Double, IN tipo_servicio INT)

BEGIN

SET @LAT = latitude;

SET @LON = longitude;

SET @Servicio = tipo_servicio;

SET @point = CONCAT(\'POINT(\',@LAT,\' \',@LON,\')\');

SET @center = GeomFromText(@point);

SET @radius = 0.01;

SET @bbox = CONCAT(\'POLYGON((\',

X(@center) - @radius, \' \', Y(@center) - @radius, \',\',

X(@center) + @radius, \' \', Y(@center) - @radius, \',\',

X(@center) + @radius, \' \', Y(@center) + @radius, \',\',

X(@center) - &#