IN(传递参数)加字段原始值实现方法
原创
©著作权归作者所有:来自51CTO博客作者hcymysql的原创作品,请联系作者获取转载授权,否则将追究法律责任
mysql> select * from t2;
+----+------+------------+
| id | name | totalcount |
+----+------+------------+
| 1 | a | 5 | (原始值是5)
| 2 | b | 6 |
| 3 | c | 7 |
| 4 | d | 8 |
| 5 | e | 9 |
| 6 | f | 10 |
+----+------+------------+
6 rows in set (0.02 sec)
mysql> call asd(1,'g',10);
Query OK, 2 rows affected (0.08 sec)
mysql> select * from t2;
+----+------+------------+
| id | name | totalcount |
+----+------+------------+
| 1 | a | 15 | (传递参数10+原始值5,等于15)
| 2 | b | 6 |
| 3 | c | 7 |
| 4 | d | 8 |
| 5 | e | 9 |
| 6 | f | 10 |
+----+------+------------+
6 rows in set (0.02 sec)
mysql> call asd(1,'g',20);
Query OK, 2 rows affected (1.23 sec)
mysql> select * from t2;
+----+------+------------+
| id | name | totalcount |
+----+------+------------+
| 1 | a | 35 | (传递参数20+原始值15,等于35)
| 2 | b | 6 |
| 3 | c | 7 |
| 4 | d | 8 |
| 5 | e | 9 |
| 6 | f | 10 |
+----+------+------------+
6 rows in set (0.02 sec)
==============================================================================================
存储过程如下:
下一篇:分组取前N记录
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
java如何实现参数传递方法
例如类似于obj.callme("abc",function(){自定义代码});运行后内部也运行了那个匿名函
Java JavaScript 框架 ViewUI javascript

















