MySQL通过创建FUNCTION以某字段实现记录的上下移

代码实现：

CREATE FUNCTION `moveUpOrDown`(recordId int(11), type int(11)) 
RETURNS int(11)
BEGIN 
	DECLARE isExecute int(11); 
	DECLARE sort1 int(11); 
	DECLARE sort2 int(11); 
	DECLARE executeId int(11);
	SELECT sort INTO sort1 FROM 表名 WHERE id=recordId;
	IF type=1
	THEN 
		SELECT count(0) INTO isExecute FROM z_label z WHERE z.sort<sort1;
		IF isExecute=0 THEN RETURN -1;
		ELSE
			SELECT z.sort INTO sort2 FROM 表名 z WHERE z.sort<sort1 ORDER BY z.sort DESC LIMIT 1;
			SELECT z.id INTO executeId FROM 表名 z WHERE z.sort<sort1 ORDER BY z.sort DESC LIMIT 1;
			UPDATE 表名 SET sort=sort1 WHERE id=executeId;
			UPDATE 表名 SET sort=sort2 WHERE id=recordId;
			RETURN 1;
		END IF;
	ELSE
		SELECT count(0) INTO isExecute FROM 表名 z WHERE z.sort>sort1;
		IF isExecute=0 THEN RETURN -1;
		ELSE
			SELECT z.sort INTO sort2 FROM 表名 z WHERE z.sort>sort1 ORDER BY z.sort DESC LIMIT 1;
			SELECT z.id INTO executeId FROM 表名 z WHERE z.sort>sort1 ORDER BY z.sort DESC LIMIT 1;
			UPDATE 表名 SET sort=sort1 WHERE id=executeId;
			UPDATE 表名 SET sort=sort2 WHERE id=recordId;
			RETURN 1;
		END IF;
	END IF;
END

入参值：
recordId：要执行上下移操作的记录主键
type：执行类型：1-上移，2-下移

返回值：
-1：已排在最前或最末，无法执行上下移
1：执行成功