wwwwb，WWWWA你们看看这个情况

2012-07-12 03:12:34 708 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

工业相机TEC散热技术：从原理到高精度成像的实战解析本文深入解析了工业相机TEC散热技术的核心原理与实战应用。通过阐述热电制冷器如何利用帕尔帖效应实现精准温控，有效抑制图像传感器暗电流噪声，从而保障高精度成像的稳定性。文章结合工业场景痛点，提供了从TEC选型、系统集成到控制逻辑的完整设计指南，并分享了不同应用场景下的实战案例，是提升工业视觉系统成像质量的关键技术解析。阅读详情

存储过程：
BEGIN
declare countj int;
SELECT COUNT(serverid) INTO countj FROM `count_serverinfo` WHERE gameid = temgameid ORDER BY serverid,days;
BEGIN
INSERT into daydate(game1,serverorder,serverid,days)
SELECT game,serverorder,serverid,MAX(IF(days=temdays,amountcount,0.00)) AS days FROM count_serverinfo GROUP BY serverid ORDER BY serverid DESC;
END;
END

php文件中的代码：
$day = $db->query("SELECT days FROM `count_serverinfo` WHERE gameid = '1' GROUP BY days asc ");
foreach($day as $key=>$days){
$db->getAll("set @temgameid='1',@temdays='".$days['days']."'");
$sql="call dier(@temgameid,@temdays)";
$db->getAll($sql);
}

这个值temdays我在php文件中从一张表里边查询出来了，然后遍历，比如说这个变量有10个值是在存储过程中循环了10次，但是插入到daydate表中的值全都是第一天的数据，为什么啊

...全文

CSV文件输入到simulink中将示波器波形和数据CSV文件保存下来进行数据分析。将波形绘制到simulink中阅读详情

yanfangphp

MySQL 57,062 成员 56,759 内容

+ 关注 + 加入社区

切换为时间正序

yanfangphp 2012-07-13

打赏
举报

问题解决了，我把循环过程放到存储过程里边了，就没有问题了

WWWWA 2012-07-13

打赏
举报

[Quote=引用 23 楼 wwwwa 的回复:]

SET @asql=CONCAT(@asql,'MAX(IF(days=\'',temdays,'\',amountcount,0.00)) AS `',temdays,'`FROM count_serverinfo GROUP BY serverid ORDER BY serverorder DESC');
SELECT @ASQL;
贴结果
[/Quote]
直接在MYSQL环境中运行，确定是否是SP的问题

yanfangphp 2012-07-13

打赏
举报

[Quote=引用 22 楼的回复:]

SELECT game,serverorder,serverid,MAX(IF(days=temdays,amountcount,0.00)) FROM count_serverinfo GROUP BY serverid ORDER BY serverorder DESC;
[/Quote]不行啊，插入表中的数据还是不循环，只插入了第一天的数据

yanfangphp 2012-07-13

打赏
举报

[Quote=引用 23 楼的回复:]

SET @asql=CONCAT(@asql,'MAX(IF(days=\'',temdays,'\',amountcount,0.00)) AS `',temdays,'`FROM count_serverinfo GROUP BY serverid ORDER BY serverorder DESC');
SELECT @ASQL;
贴结果
[/Quote]报错：
mySQL Query Error
Date: 2012-7-13 09:44:22
SQLID: Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
Error: set @temgameid='1',@temdays='2'

WWWWA 2012-07-13

打赏
举报

SET @asql=CONCAT(@asql,'MAX(IF(days=\'',temdays,'\',amountcount,0.00)) AS `',temdays,'`FROM count_serverinfo GROUP BY serverid ORDER BY serverorder DESC');
SELECT @ASQL;
贴结果

ACMAIN_CHM 2012-07-12

打赏
举报

SELECT game,serverorder,serverid,MAX(IF(days=temdays,amountcount,0.00)) FROM count_serverinfo GROUP BY serverid ORDER BY serverorder DESC;

yanfangphp 2012-07-12

打赏
举报

DELIMITER $$
DROP PROCEDURE IF EXISTS `diera`;
CREATE DEFINER=`root`@`localhost` PROCEDURE `diera`(
INOUT temdays INT,
IN temgameid INT,
)
BEGIN
DECLARE countj INT;
SELECT COUNT(DISTINCT(days)) INTO countj FROM `count_serverinfo` WHERE gameid = ",temgameid,"';
BEGIN
INSERT into daydate(i,game1,serverorder,serverid,day1)
SELECT game,serverorder,serverid,MAX(IF(days='",temdays ,"',amountcount,0.00)) AS '",days,"' FROM count_serverinfo GROUP BY serverid ORDER BY serverorder DESC;
END;
END $$
DELIMITER ;

yanfangphp 2012-07-12

打赏
举报

DELIMITER $$
DROP PROCEDURE IF EXISTS `diera`;
CREATE DEFINER=`root`@`localhost` PROCEDURE `dier`(
INOUT temdays INT,
IN temgameid INT,
)
BEGIN
DECLARE countj INT;
SELECT COUNT(DISTINCT(days)) INTO countj FROM `count_serverinfo` WHERE gameid = '",temgameid,"';
BEGIN
INSERT into daydate(i,game1,serverorder,serverid,day1)
SELECT game,serverorder,serverid,MAX(IF(days='",temdays ,"',amountcount,0.00)) AS '",days,"' FROM count_serverinfo GROUP BY serverid ORDER BY

serverorder DESC;
END;
END $$
DELIMITER ;

ACMAIN_CHM 2012-07-12

打赏
举报

为什么不肯贴你完整的语句啊？你的 create procedure 在哪儿？

yanfangphp 2012-07-12

打赏
举报

BEGIN
declare countj int;
SELECT COUNT(serverid) INTO countj FROM `count_serverinfo` WHERE gameid = temgameid ORDER BY serverid,days;
BEGIN
SET @asql='INSERT into daydate(game1,serverorder,serverid,days)';
SET @asql=CONCAT(@asql,'SELECT game,serverorder,serverid,');
SET @asql=CONCAT(@asql,'MAX(IF(days=\'',temdays,'\',amountcount,0.00)) AS `',temdays,'`FROM count_serverinfo GROUP BY serverid ORDER BY serverorder DESC');
prepare stml from @asql;
execute stml;
deallocate prepare stml;
END;
END

yanfangphp 2012-07-12

打赏
举报

[Quote=引用 10 楼的回复:]

set @temgameid='1',@temdays='1';
call dier(@temgameid,@temdays) 我这样在mysql中运行，查出来的数据正确啊，

我把sql输出，我限制了只循环两次，你看他就出来了两条sql语句，而且这个temdays值也是变化的，
但是在存储过程中显示的虽然是两次查询结果，但都是第一天的数据
set @temgameid='1',@te……
[/Quote]我都这样写了，还是一个样子啊，真蛋疼啊
SET @asql='INSERT into daydate(game1,serverorder,serverid,days)';
SET @asql=CONCAT(@asql,'SELECT game,serverorder,serverid,');
SET @asql=CONCAT(@asql,'MAX(IF(days=\'',temdays,'\',amountcount,0.00)) AS `',temdays,'`FROM count_serverinfo GROUP BY serverid ORDER BY serverorder DESC');

ACMAIN_CHM 2012-07-12

打赏
举报

[Quote]不好意思，我这是又写了一次存储过程：sql语句中的两个变量忘记修改了，，[/Quote]直接贴出你的 create procedure 语句，否则别人根本不知道你的语句是什么。

wwwwb 2012-07-12

打赏
举报

[Quote=引用 13 楼 yanfangphp 的回复:]

按照你这样的写法语法不对啊，我换双引号也不行勒
[/Quote]
你的代码是什么？建议你看看MYSQL的HELP、及我的示例进行修改

yanfangphp 2012-07-12

打赏
举报

[Quote=引用 12 楼的回复:]

引用 8 楼的回复:

DELIMITER $$
DROP PROCEDURE IF EXISTS `diera`;
CREATE DEFINER=`root`@`localhost` PROCEDURE `dier`(
INOUT temdays INT,
IN temgameid INT,
)
BEGIN
DECLARE countj INT;
SELECT COUN……
[/Quote]不好意思，我这是又写了一次存储过程：sql语句中的两个变量忘记修改了，，
SELECT COUNT(DISTINCT(days)) INTO countj FROM `count_serverinfo` WHERE gameid = '",gameid,"';
这句中gameid=temgameid

SELECT game,serverorder,serverid,MAX(IF(days='",days,"',amountcount,0.00)) AS '",days,"' FROM count_serverinfo GROUP BY serverid ORDER BY
这句中：days='",days,"', 后边的days=temdays

yanfangphp 2012-07-12

打赏
举报

按照你这样的写法语法不对啊，我换双引号也不行勒

ACMAIN_CHM 2012-07-12

打赏
举报

[Quote=引用 8 楼的回复:]

DELIMITER $$
DROP PROCEDURE IF EXISTS `diera`;
CREATE DEFINER=`root`@`localhost` PROCEDURE `dier`(
INOUT temdays INT,
IN temgameid INT,
)
BEGIN
DECLARE countj INT;
SELECT COUNT(DISTINCT(……
[/Quote]你的存储过程中哪儿用到了这两个参数？
INOUT temdays INT,
IN temgameid INT,

wwwwb 2012-07-12

打赏
举报

我估计问题出在
SELECT game,serverorder,serverid,MAX(IF(days='",days,"',amountcount,0.00)) AS '",days,"' FROM count_serverinfo GROUP BY serverid ORDER BY
这句上，上个帖子已经说过，要用字符串累加生成SQL语句，再执行的方法

SET @asql='SELECT game,serverorder,serverid,';
SET @asql=CONCAT(@asql,'MAX(IF(days=\'',days,'\',amountcount,0.00)) AS `',days,'`');

....
prepare stml from @asql;
execute stml;

MAX(IF(days='",days,"',amountcount,0.00))
看看days中的值，你是否要计算比如days=‘01’ OR 02的值

MAX(IF(days='01',amountcount,0.00))
这2句是否有区别

yanfangphp 2012-07-12

打赏
举报

set @temgameid='1',@temdays='1';
call dier(@temgameid,@temdays) 我这样在mysql中运行，查出来的数据正确啊，

我把sql输出，我限制了只循环两次，你看他就出来了两条sql语句，而且这个temdays值也是变化的，
但是在存储过程中显示的虽然是两次查询结果，但都是第一天的数据
set @temgameid='1',@temdays='1'
call dier(@temgameid,@temdays)
set @temgameid='1',@temdays='2'
call dier(@temgameid,@temdays)

wwwwb 2012-07-12

打赏
举报

在MYSQL中调用SP，结果如何

yanfangphp 2012-07-12

打赏
举报

DELIMITER $$
DROP PROCEDURE IF EXISTS `diera`;
CREATE DEFINER=`root`@`localhost` PROCEDURE `dier`(
INOUT temdays INT,
IN temgameid INT,
)
BEGIN
DECLARE countj INT;
SELECT COUNT(DISTINCT(days)) INTO countj FROM `count_serverinfo` WHERE gameid = '",gameid,"';
BEGIN
INSERT into daydate(i,game1,serverorder,serverid,day1)
SELECT game,serverorder,serverid,MAX(IF(days='",days,"',amountcount,0.00)) AS '",days,"' FROM count_serverinfo GROUP BY serverid ORDER BY

serverorder DESC;
END;
END $$
DELIMITER ;

加载更多回复（7）

wwwwb，WWWWA你们看看这个情况

相关推荐