获取MySQL更新语句中受影响的行数? [英] Get the number of affected rows in a MySQL update statement?
本文介绍了获取MySQL更新语句中受影响的行数?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我已经在MySQL中存储了过程,如下所示:
I have stored procedure in MySQL, something like the below:
create procedure SP_Test (input1 varchar(20))
begin
update Table1 set Val1='Val' where country=input1;
//I want to see if this update changed how many rows and
//do some specific action based on this number
....
end
如何确定此更新更改了多少行?
How can I determine how many rows were changed by this update?
推荐答案
使用 查看全文