MySql存储过程带个字符处参数,怎么写的
存储过程中四个int参数,
要转化成字符串用在GeomFromText中,这么写的
CREATE PROCEDURE `SpatialTest`(n int, w Int, s int, e int)
BEGIN
SET @p='Polygon(('+w+' '+ n+','+w+' '+s+','+e+' '+s+','+e+' '+n+'))';
SELECT ShapeGeo FROM roadl_arc WHERE MBRContains(GeomFromText(@p),ShapeGeo);
END $$
好像不对,正确的该怎么写呢