MySQL存储过程

CREATE PROCEDURE p_dl_user_add(IN idcard VARCHAR(50),

    IN uname VARCHAR(100),

    IN ulname VARCHAR(100), 

    IN usrpass VARCHAR(100),

    IN mphone varchar(11),

    IN source CHAR(1))

begin  

    declare uid varchar(50);

        DECLARE EXIT HANDLER FOR SQLEXCEPTION

        BEGIN

                ROLLBACK; -- 发生异常时回滚

                SELECT '9999' msgno,'数据库连接异常！' msg FROM DUAL;    

        END;

        BEGIN

            select GET_XLH('dl_user.uid') into uid;

            insert into dl_user(uid,user_type,uname,idcard,ulname,usrpass,mphone,source,qianyueFlag) values(uid,'3002',uname,idcard,ulname,usrpass,mphone,source,'1');

            insert into dl_user_register(uid,register_time) values(uid,'%s');

            insert into dl_z1_user_integral(User_id) values(uid);

            insert into dl_user_r_role(rur_id,user_type,uid) values(GET_XLH('dl_user_r_role.rur_id'),'1006',uid);

            select '0000' msgno,'注册成功！' msg from dual;

        END;

        COMMIT WORK;

    END

声明变量语法：declare uid varchar(50);
 为变量赋值语法：set uid='123456';