这个游标怎么没结果呢？

Question

mysql> select*from 入库单表;
+------+---------------------+--------------+----------------+------+------+----
--+------+------+------+
| 单号 | 入库日期            | 品名         | 供货商编号     | 颜色 | 规格 | 数
量 | 单位 | 单价 | 金额 |
+------+---------------------+--------------+----------------+------+------+----
--+------+------+------+
| 001  | 2011-05-16 16:03:02 | CP           |                |      |      |   1
2 |      |    5 |   60 |
|      | 2011-05-23 15:21:29 | 水杯         |                | 白   |      |
0 |      |    0 |    0 |
|      | 2011-05-23 15:21:29 | 水杯         |                | 白   |      |
0 |      |    0 |    0 |
|      | 2011-05-23 15:21:29 | SQL 入门经典 | 人民邮电出版社 |      |      |
0 |      |    0 |    0 |
+------+---------------------+--------------+----------------+------+------+----
--+------+------+------+
4 rows in set (0.03 sec)mysql> DELIMITER //mysql>  CREATE PROCEDURE P()
    -> begin
    -> declare t text;
    ->  DECLARE o CURSOR FOR SELECT 品名 from 入库单表;
    ->  open o;
    ->  fetch o into t;
    ->  select @t;
    ->  close o;
    -> end//
Query OK, 0 rows affected (0.00 sec)mysql> call p()//
+------+
| @t   |
+------+
| NULL |
+------+
1 row in set (0.00 sec)Query OK, 0 rows affected (0.02 sec)

Answer 1

select @t; 改成 select t;@t 并不是 t