关于使用存储过程造数据

添加项目user的存储过程,在dh_account库进行call调用:

DELIMITER $$
create procedure add_user(in name1 varchar(64),IN name_suffix_Start INT   )
BEGIN
    DECLARE name1 varchar(64);
    declare a tinyint;
    set a=0;
    while a<10 do
       INSERT INTO dh_account.tb_user (name,phone,email,password,state,sex,head_img,entity,create_date,update_date)
        VALUES (concat('苦瓜',name_suffix_Start),'15828326397','allah@qq.com','gesge',1,1,null,null,null,null);
       set a=a+1;
       SET name_suffix_Start = name_suffix_Start + 1;
    end while;
END
$$

添加项目成员的存储过程

```sql
DELIMITER //
create procedure add_employee_zxx(in name1 varchar(64),IN name_suffix_Start INT )
BEGIN
    #DECLARE name1 varchar(64);
    Declare _ecode varchar(8) CHARACTER SET utf8;
    declare userId bigint;
    declare a bigint;

      #从tb_user表中取user_id存入游标
        declare cur cursor for select id from dh_account.tb_user where id not in(select user_id from dh_enterprise.employee where del_flag=1 and project_id=82);
        open cur;
        set a=0;
        while a<2 do
    #取出游标值至变量中
            fetch cur into userId;
            INSERT INTO dh_enterprise.employee (code,name,phone,portrait,sex,age,identity_card,working_unit,construction_site,work_type,
                                            expire_date,user_id,
                                           department_id,project_id,del_flag,change_dept_time,update_time,create_time)
            VALUES (upper(left(uuid(),8)),concat(name1,name_suffix_Start),null,'gesge',1,20,null,null,null,null,null,userId,635,82,1,null,null,null);
            SET name_suffix_Start = name_suffix_Start + 1;
            set a=a+1;
        end while;

END
//