Question

mysql存储过程能返回update更新操作的结果吗

Answer 1

在存储过程中使用ROW_COUNT()
mysql>
select
*
from
a1;
->
//
+------+-------+
|
id
|
name
|
+------+-------+
|
1
|
timac
|
+------+-------+
1
row
in
set
(0.00
sec)
mysql>
\d
;
mysql>
update
a1
set
name='king'
where
id=1;
Query
OK,
1
row
affected
(0.00
sec)
Rows
matched:
1
Changed:
1
Warnings:
0
mysql>
select
row_count();
+-------------+
|
row_count()
|
+-------------+
|
1
|
+-------------+
1
row
in
set
(0.00
sec)
mysql>
insert
into
a1
values(2,'K1'),(3,'K2');
Query
OK,
2
rows
affected
(0.00
sec)
Records:
2
Duplicates:
0
Warnings:
0
mysql>
select
row_count();
+-------------+
|
row_count()
|
+-------------+
|
2
|
+-------------+
1
row
in
set
(0.00
sec)
mysql>
update
a1
set
name='kings'
where
id=4;
Query
OK,
0
rows
affected
(0.00
sec)
Rows
matched:
0
Changed:
0
Warnings:
0
mysql>
select
row_count();
+-------------+
|
row_count()
|
+-------------+
|
0
|
+-------------+
1
row
in
set
(0.00
sec)
只有返回的row_count()值大小还判断是否成功