MySQL 带INOUT参数执行搜索提示的存储过程

DELIMITER $$USE `b10k`$$DROP PROCEDURE IF EXISTS `sp_suggest`$$CREATE DEFINER=`luth`@`%` PROCEDURE `sp_suggest`(IN query_columnVARCHAR(100),   /*被检索的字段名*/IN      keywordVARCHAR(100),/*检索的关键字*/IN table_nameVARCHAR(100),/*被检索的表名*/INOUT result_countINT/*要取出匹配记录的数量*/    )COMMENT '执行关键字搜索'BEGIN    /*定义变量*/    DECLARE m_begin_row INT DEFAULT 0;    DECLARE m_where_string CHAR(128);    DECLARE m_order_string CHAR(128);    DECLARE m_limit_string CHAR(64);        /*构造语句*/        SET m_begin_row = result_count;    SET m_where_string = CONCAT(' WHERE ', query_column, ' LIKE \'', keyword, '%\' ');    SET m_order_string = CONCAT(' ORDER BY ', query_column);    SET m_limit_string = CONCAT(' LIMIT ', result_count);            SET @COUNT_STRING = CONCAT('SELECT DISTINCT COUNT(*) INTO @ROWS_TOTAL FROM ', table_name, ' ', m_where_string, ' ', m_order_string, ' ', m_limit_string);    SET @MAIN_STRING = CONCAT('SELECT DISTINCT ', query_column, ' FROM ', table_name, ' ', m_where_string, ' ', m_order_string, ' ', m_limit_string);        /*预处理*/    PREPARE count_stmt FROM @COUNT_STRING;    EXECUTE count_stmt;    DEALLOCATE PREPARE count_stmt;    SET result_count = @ROWS_TOTAL;            PREPARE main_stmt FROM @MAIN_STRING;    EXECUTE main_stmt;    DEALLOCATE PREPARE main_stmt;END$$DELIMITER ;/*调用*/SET @aa=10;CALL sp_suggest('latin_name','A','species',@aa);SELECT @aa;