想把表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
解决方案 »
- 创建mysql function的时候出现了错误 Unknown system variable 'Done'
- 为什么我的这个Navicat for MySQL连接不起呢??!!!!每次都出现2003-Can't connect to MySQL on 'localhost; (10061) 请哪位好心人告诉我答案好妈???
- .sql文件怎么导入mysql?在网上查了很多方法都不成功!在线等
- 第一次发帖、、哪位仁兄有开发网站时用mysql建表的实例,,学这个急用,mysql我是新手急需一个例子。。
- 急急,求高手解答触发器错误
- 地名数据库设计问题
- [求助]如何用mysql求两个field的交集
- 请问一个简单的查询怎么写?
- 如何使用MYSQL
- 表格的数据如何去重啊?
- mysql declare 变量应用报错,在线等……
- 是否建立索引的问题
;