想把表A中的数据排序,取出前X个,插入到表B中,同时插入另外两个参数DROP PROCEDURE IF EXISTS SetValue;
CREATE PROCEDURE SetValue(
IN paramA INT,
IN paramB INT,
IN paramC INT,
IN paramD INT)
BEGIN SET @result = 0;
SET @prepareStatement = CONCAT("SELECT RoleName, Score FROM A WHERE attr=", paramA ," ORDER BY Score DESC limit ", paramB );
INSERT INTO B values (paramC ,paramD ,上面select的结果) ;
PREPARE stmt FROM @prepareStatement;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
END
CREATE PROCEDURE SetValue(
IN paramA INT,
IN paramB INT,
IN paramC INT,
IN paramD INT)
BEGIN SET @result = 0;
SET @prepareStatement = CONCAT("SELECT RoleName, Score FROM A WHERE attr=", paramA ," ORDER BY Score DESC limit ", paramB );
INSERT INTO B values (paramC ,paramD ,上面select的结果) ;
PREPARE stmt FROM @prepareStatement;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
END
;