07-IDEA集成Database

1.查询最大条数

2. 大写关键字

3. 游标越界

DELIMITER $$
DROP PROCEDURE IF EXISTS kk;
CREATE PROCEDURE kk()
BEGIN
    DECLARE orgName VARCHAR(1024);
    DECLARE flag INT;
    # 创建游标
    DECLARE orgCursor CURSOR FOR SELECT f_org_name FROM t_project_org_detail LIMIT 4;
    OPEN orgCursor;
    FETCH orgCursor INTO orgName;
    SELECT orgName;
    FETCH orgCursor INTO orgName;
    SELECT orgName;
    FETCH orgCursor INTO orgName;
    SELECT orgName;
    FETCH orgCursor INTO orgName;
    SELECT orgName;
    FETCH orgCursor INTO orgName;
    SELECT orgName;
    CLOSE orgCursor;
END $$
DELIMITER ;
CALL kk();