DROP FUNCTION IF EXISTS test; CREATE FUNCTION test() RETURNS varchar(30) CHARSET utf8 BEGIN DECLARE rows_start int; DECLARE username varchar(30); DECLARE temp_sql varchar(300);
SET rows_start=2; SELECT user_name INTO username FROM conf_user_info ORDER BY id LIMIT rows_start,1; return username;
END; 经测试,limit后可以跟变量
在MYSQL 5.5.18下可以用, DELIMITER $$USE `aa`$$DROP FUNCTION IF EXISTS `test`$$CREATE DEFINER=`root`@`localhost` FUNCTION `TEST`() RETURNS VARCHAR(30) CHARSET utf8 BEGIN DECLARE rows_start INT; DECLARE username VARCHAR(30); DECLARE temp_sql VARCHAR(300);
SET rows_start=2; SELECT ORDERID INTO username FROM AA1 ORDER BY NUMBER LIMIT rows_start,1; RETURN username;
END$$DELIMITER ;select test()
在MYSQL 5.5.18下可以用, DELIMITER $$USE `aa`$$DROP FUNCTION IF EXISTS `test`$$CREATE DEFINER=`root`@`localhost` FUNCTION `TEST`() RETURNS VARCHAR(30) CHARSET utf8 BEGIN DECLARE rows_start INT; DECLARE username VARCHAR(30); DECLARE temp_sql VARCHAR(300);
SET rows_start=2; SELECT ORDERID INTO username FROM AA1 ORDER BY NUMBER LIMIT rows_start,1; RETURN username;
CREATE FUNCTION test() RETURNS varchar(30) CHARSET utf8
BEGIN DECLARE rows_start int;
DECLARE username varchar(30);
DECLARE temp_sql varchar(300);
SET rows_start=2;
SELECT user_name INTO username FROM conf_user_info ORDER BY id LIMIT rows_start,1;
return username;
END;
经测试,limit后可以跟变量
DELIMITER $$USE `aa`$$DROP FUNCTION IF EXISTS `test`$$CREATE DEFINER=`root`@`localhost` FUNCTION `TEST`() RETURNS VARCHAR(30) CHARSET utf8
BEGIN
DECLARE rows_start INT;
DECLARE username VARCHAR(30);
DECLARE temp_sql VARCHAR(300);
SET rows_start=2;
SELECT ORDERID INTO username FROM AA1 ORDER BY NUMBER LIMIT rows_start,1;
RETURN username;
END$$DELIMITER ;select test()
DELIMITER $$USE `aa`$$DROP FUNCTION IF EXISTS `test`$$CREATE DEFINER=`root`@`localhost` FUNCTION `TEST`() RETURNS VARCHAR(30) CHARSET utf8
BEGIN
DECLARE rows_start INT;
DECLARE username VARCHAR(30);
DECLARE temp_sql VARCHAR(300);
SET rows_start=2;
SELECT ORDERID INTO username FROM AA1 ORDER BY NUMBER LIMIT rows_start,1;
RETURN username;
END$$DELIMITER ;select test()