gistfile1.txt

MariaDB [test]> create procedure demo()
    -> BEGIN
    ->    DECLARE TARGETID INT ;
    ->    DECLARE QDTIME DATETIME ;
    ->    DECLARE done INT DEFAULT FALSE ;
    ->    DECLARE CUR1 CURSOR FOR SELECT id,qdtime FROM axd_user WHERE authstatus=6;
    ->    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
    ->    OPEN CUR1;
    ->  judge_loop: LOOP
    ->    FETCH CUR1 INTO TARGETID, QDTIME;
    ->    IF done THEN
    ->      LEAVE judge_loop;
    ->    END IF;
    ->
    ->    SELECT TARGETID, QDTIME;
    -> END LOOP;
    -> CLOSE CUR1;
    -> END;|
Query OK, 0 rows affected (0.03 sec)

MariaDB [test]> call demo()|
+----------+--------+
| TARGETID | QDTIME |
+----------+--------+
|    10001 | NULL   |
+----------+--------+
1 row in set (0.00 sec)

+----------+--------+
| TARGETID | QDTIME |
+----------+--------+
|    10004 | NULL   |
+----------+--------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

# the column qdtime value shoud be the following value ,not NULL

MariaDB [test]>  SELECT id,qdtime FROM axd_user WHERE authstatus=6;
    -> |
+-------+---------------------+
| id    | qdtime              |
+-------+---------------------+
| 10001 | 2015-03-05 12:15:36 |
| 10004 | 2015-03-05 12:15:36 |
+-------+---------------------+
2 rows in set (0.00 sec)

MariaDB [test]> show create table axd_user\G
*************************** 1. row ***************************
       Table: axd_user
Create Table: CREATE TABLE "axd_user" (
  "id" int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'xx',
  "username" varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'xx',
  "phonenumber" varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'xx',
  "schoolid" int(10) unsigned NOT NULL COMMENT 'xx',
  "schoolname" varchar(100) COLLATE utf8_bin NOT NULL COMMENT 'xx',
  "authstatus" tinyint(3) unsigned NOT NULL COMMENT 'xx',
  "dxcjlid" int(10) unsigned DEFAULT NULL COMMENT 'xx',
  "dxcjlname" varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'xx',
  "qdrid" int(10) unsigned DEFAULT NULL COMMENT 'xx',
  "qdrname" varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'xx',
  "qdtime" datetime DEFAULT NULL COMMENT 'xx',
  "yyrid" int(10) unsigned DEFAULT NULL COMMENT 'xx',
  "yyrname" varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'xx',
  "yymqtime" datetime DEFAULT NULL COMMENT 'xx',
  "mqrid" int(10) unsigned DEFAULT NULL COMMENT 'xx',
  "mqrname" varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'xx',
  "mqtime" datetime DEFAULT NULL COMMENT 'xx',
  "reviewerid" int(10) unsigned DEFAULT NULL COMMENT 'xx',
  "reviewername" varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'xx',
  "reviewtime" datetime DEFAULT NULL COMMENT 'xx',
  "reviewresult" varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'xx',
  "creditlimit" decimal(8,2) unsigned NOT NULL COMMENT 'xx',
  "failtime" tinyint(3) unsigned NOT NULL COMMENT 'xx',
  "createtime" datetime NOT NULL COMMENT 'xx',
  "sqcloseid" int(10) unsigned DEFAULT NULL COMMENT 'xx',
  "sqclosename" varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'xx',
  "sqclosereason" varchar(1000) COLLATE utf8_bin DEFAULT NULL COMMENT 'xx',
  "sqclosetime" datetime DEFAULT NULL COMMENT 'xxx',
  "sqclosestat" enum('xx','xx','xx') COLLATE utf8_bin NOT NULL DEFAULT 'xx',
  "recommid" int(10) unsigned DEFAULT NULL COMMENT 'xxx',
  "recommname" varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT 'xx',
  "schoolss" varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'xxx',
  "schoolxq" varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT 'xx',
  "sex" enum('man','woman') COLLATE utf8_bin DEFAULT NULL COMMENT 'xx',
  "usercard" varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'xx',
  "tjyytimenum" int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'xx',
  PRIMARY KEY ("id")
) ENGINE=InnoDB AUTO_INCREMENT=10005 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='xx'
1 row in set (0.00 sec)