创建一个MySQL存储过程来计算受MySQL查询影响的行数吗？
以下是计算受MySQL查询影响的行数的过程-
mysql> Delimiter //
mysql> CREATE PROCEDURE `query`.`row_cnt` (IN command VarChar(60000))
-> BEGIN
-> SET @query = command;
-> PREPARE stmt FROM @query;
-> EXECUTE stmt;
-> SELECT ROW_COUNT() AS 'Affected rows';
-> END //
mysql> Delimiter ;
mysql> Create table Testing123(First Varchar(20), Second Varchar(20));
mysql> CALL row_cnt("INSERT INTO testing123(First,Second) Values('Testing First','Testing Second');");
+---------------+
| Affected rows |
+---------------+
| 1 |
+---------------+
1 row in set (0.10 sec)热门推荐
10 青春告白祖国简短祝福语
11 新年祝福语简短聪明可爱
12 许愿星姐妹祝福语简短
13 回家长的祝福语简短
14 公司28 周年祝福语简短
15 新郎表白成语祝福语简短
16 浪漫的生日祝福语简短
17 药店祝福语简短10字
18 孙女结婚姥姥祝福语简短