21,886
社区成员
发帖
与我相关
我的任务
分享
mysql> create procedure pro1()
-> begin
-> declare d int;
-> select max(id) into d from o;
-> set @dd=0;
-> select max(id) into @dd from o;
-> end;
-> //
Query OK, 0 rows affected (0.05 sec)
mysql> call pro1;
-> //
Query OK, 0 rows affected (0.00 sec)
mysql> select @dd;
-> //
+------+
| @dd |
+------+
| 2 |
+------+
1 row in set (0.00 sec)
mysql> select d//
ERROR 1054 (42S22): Unknown column 'd' in 'field list'