高分求助mysql 存储过程报错以及如何返回受影响的行数

2014-05-27 12:03:12 555 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

AMD 3D V-Cache技术解析：CPU缓存堆叠如何突破性能瓶颈在半导体领域，缓存（Cache）是提升处理器性能的关键技术，其核心原理是在高速CPU核心与慢速主存之间建立数据中转站，以缓解“内存墙”问题。随着摩尔定律放缓，传统平面扩展缓存面临面积成本高、延迟增加等挑战。3D封装技术应运而生，通过垂直堆叠实现极致的互联密度与带宽，成为突破性能瓶颈的重要工程路径。这项技术的价值在于能以更优的功耗和延迟，显著提升缓存容量，从而改善游戏、科学计算等数据密集型应用的性能。以AMD 3D V-Cache为代表的Hybrid Bonding（混合键合）工艺，正是这一趋势的典型实践，它阅读详情



DELIMITER $$

USE `xiehou_3`$$

DROP PROCEDURE IF EXISTS `proc`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `proc`(IN iuid INT,IN icnt INT)

BEGIN

     DECLARE idate DATE;

     SELECT `date` INTO idate FROM tb_act20140602_user_value WHERE uid=iuid;

     IF idate IS NULL THEN   

        INSERT INTO tb_act20140602_user_value VALUES(iuid,icnt,NOW(),icnt,icnt,NOW());

     ELSEIF idate=CONVERT(NOW(),DATE) THEN

        UPDATE tb_act20140602_user_value SET daycnt=daycnt+icnt,maxcnt=maxcnt+icnt,`count`=`count`+icnt,lastModifyTime=NOW() WHERE uid=iuid;

     ELSE

        UPDATE tb_act20140602_user_value SET daycnt=icnt,maxcnt=maxcnt+icnt,`count`=`count`+icnt,lastModifyTime=NOW(),`date`=NOW() WHERE uid=iuid;

     END IF;

    END$$

DELIMITER;

 

以上语句执行后



(0 row(s) affected)

Execution Time : 00:00:00:000

Transfer Time  : 00:00:00:047

Total Time     : 00:00:00:047



(0 row(s) affected)

Execution Time : 00:00:00:032

Transfer Time  : 00:00:01:201

Total Time     : 00:00:01:233



(0 row(s) affected)

Execution Time : 00:00:00:000

Transfer Time  : 00:00:00:015

Total Time     : 00:00:00:015



错误码: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER' at line 1



Execution Time : 00:00:00:000

Transfer Time  : 00:00:00:000

Total Time     : 00:00:00:000





存储过程proc创建成功





调用结果



(1 row(s) affected)

Execution Time : 00:00:00:093

Transfer Time  : 00:00:00:000

Total Time     : 00:00:00:093



我就想问为毛有一行报错



顺便问下如何返回受影响的行数

...全文

新四化浪潮下，中年整车诊断工程师的黄金突围路摘要本文探讨了汽车电子诊断工程师在当前行业变革中的独特优势与发展路径。作者作为从业者指出，整车诊断岗位在汽车"新四化"浪潮中呈现"逆生长"特性：技术壁垒高、经验复利强、市场需求持续增长。中年工程师凭借丰富的案例积累和实战经验成为行业稀缺人才，薪资水平显著高于同龄段其他技术岗位。文章分析了四条职业发展路径（技术专家、技术管理、细分深耕、横向拓展），并警示了三大职业风险（执行层局限、技术停滞、成果沉淀不足）。最后提出具体建议，强调掌握UDS高阶、DoIP以太网诊断等核心技术的重要性，为中年技术人提供了清晰的职阅读详情

seqwait

MySQL 57,062 成员 56,759 内容

+ 关注 + 加入社区

切换为时间正序

wwwwb 2014-05-29

打赏
举报

select ROW_COUNT()　即可得到 select ROW_COUNT() into @aa　存入变量

seqwait 2014-05-29

打赏
举报

引用 2 楼 WWWWA 的回复:

DELIMITER $$：前面有无空格用ROW_COUNT()返回行数

引用 6 楼 hucuibai 的回复:

[quote=引用楼主 oZhiMing12 的回复:]


DELIMITER $$
USE `xiehou_3`$$
DROP PROCEDURE IF EXISTS `proc`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `proc`(IN iuid INT,IN icnt INT)
BEGIN
     DECLARE idate DATE;
     SELECT `date` INTO idate FROM tb_act20140602_user_value WHERE uid=iuid;
     IF idate IS NULL THEN   
        INSERT INTO tb_act20140602_user_value VALUES(iuid,icnt,NOW(),icnt,icnt,NOW());
     ELSEIF idate=CONVERT(NOW(),DATE) THEN
        UPDATE tb_act20140602_user_value SET daycnt=daycnt+icnt,maxcnt=maxcnt+icnt,`count`=`count`+icnt,lastModifyTime=NOW() WHERE uid=iuid;
     ELSE
        UPDATE tb_act20140602_user_value SET daycnt=icnt,maxcnt=maxcnt+icnt,`count`=`count`+icnt,lastModifyTime=NOW(),`date`=NOW() WHERE uid=iuid;
     END IF;
    END$$
DELIMITER;
 
以上语句执行后

(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:047
Total Time     : 00:00:00:047

(0 row(s) affected)
Execution Time : 00:00:00:032
Transfer Time  : 00:00:01:201
Total Time     : 00:00:01:233

(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:015
Total Time     : 00:00:00:015

错误码: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER' at line 1

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000


存储过程proc创建成功


调用结果

(1 row(s) affected)
Execution Time : 00:00:00:093
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:093

我就想问为毛有一行报错

顺便问下如何返回受影响的行数

最后一行DELIMITER ; 中间没空格[/quote] 嗯,加上空格就对了,在问下怎么在resultset中获取受影响的行数呢??

hucuibai 2014-05-27

打赏
举报

引用楼主 oZhiMing12 的回复:


DELIMITER $$
USE `xiehou_3`$$
DROP PROCEDURE IF EXISTS `proc`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `proc`(IN iuid INT,IN icnt INT)
BEGIN
     DECLARE idate DATE;
     SELECT `date` INTO idate FROM tb_act20140602_user_value WHERE uid=iuid;
     IF idate IS NULL THEN   
        INSERT INTO tb_act20140602_user_value VALUES(iuid,icnt,NOW(),icnt,icnt,NOW());
     ELSEIF idate=CONVERT(NOW(),DATE) THEN
        UPDATE tb_act20140602_user_value SET daycnt=daycnt+icnt,maxcnt=maxcnt+icnt,`count`=`count`+icnt,lastModifyTime=NOW() WHERE uid=iuid;
     ELSE
        UPDATE tb_act20140602_user_value SET daycnt=icnt,maxcnt=maxcnt+icnt,`count`=`count`+icnt,lastModifyTime=NOW(),`date`=NOW() WHERE uid=iuid;
     END IF;
    END$$
DELIMITER;
 
以上语句执行后

(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:047
Total Time     : 00:00:00:047

(0 row(s) affected)
Execution Time : 00:00:00:032
Transfer Time  : 00:00:01:201
Total Time     : 00:00:01:233

(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:015
Total Time     : 00:00:00:015

错误码: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER' at line 1

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000


存储过程proc创建成功


调用结果

(1 row(s) affected)
Execution Time : 00:00:00:093
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:093

我就想问为毛有一行报错

顺便问下如何返回受影响的行数

最后一行DELIMITER ; 中间没空格

hucuibai 2014-05-27

打赏
举报


USE `xiehou_3`;
DROP PROCEDURE IF EXISTS `proc`;
DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `proc`(IN iuid INT,IN icnt INT)
BEGIN
     DECLARE idate DATE;
     SELECT `date` INTO idate FROM tb_act20140602_user_value WHERE uid=iuid;
     IF idate IS NULL THEN   
        INSERT INTO tb_act20140602_user_value VALUES(iuid,icnt,NOW(),icnt,icnt,NOW());
     ELSEIF idate=CONVERT(NOW(),DATE) THEN
        UPDATE tb_act20140602_user_value SET daycnt=daycnt+icnt,maxcnt=maxcnt+icnt,`count`=`count`+icnt,lastModifyTime=NOW() WHERE uid=iuid;
     ELSE
        UPDATE tb_act20140602_user_value SET daycnt=icnt,maxcnt=maxcnt+icnt,`count`=`count`+icnt,lastModifyTime=NOW(),`date`=NOW() WHERE uid=iuid;
     END IF;
END
$$

seqwait 2014-05-27

打赏
举报

引用 1 楼 benluobobo 的回复:

错误码: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the 贴完整定义返回变量rowCount select ROW_COUNT() into rowCount return rowCount

贴完整了,往右托

ACMAIN_CHM 2014-05-27

打赏
举报

这段语句是在什么工具中执行的？请在MYSQL自带的命令行工具中进行测试。

WWWWA 2014-05-27

打赏
举报

DELIMITER $$：前面有无空格用ROW_COUNT()返回行数

benluobo 2014-05-27

打赏
举报

错误码: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the 贴完整定义返回变量rowCount select ROW_COUNT() into rowCount return rowCount

高分求助mysql 存储过程报错以及如何返回受影响的行数

相关推荐