存储过程--------mysql

drop procedure if EXISTS inserts;
create PROCEDURE inserts(in param int)
begin
while param < 1 do
insert into systemuser select replace(UUID(), '-', '') AS SYSTEMUSERGUID, concat(USERNAME, '_',param) AS USERNAME, LOGINNAME ,
PASSWORD , NICKNAME ,
SEX , SERIAL ,
ISENABLED , ORDERNO ,
NATIONALITY , BIRTHPLACE ,
MARITAL , POLITICS ,
SCHOOL , PROFESSION ,
BIRTHDATE , IDCARD ,
PHOTOSURL , RANKID ,
ZHICHENGID , POSITIONID ,
STATE , PHONE ,
MOBILE , EMAIL ,
POSTCODE , ADDRESS ,
SAFEPATH , CREATETIME ,
REMARK , CERTIFYMESSAGE ,
WRONGPASSCOUNT , SIGNIMG
from systemuser where LOGINNAME = 'admin' ;
set param = param +1;
end while;
end;
SET @param = 0;
call inserts(@param);

 

 

 

 

 

主要是依据哪条数据进行添加----------

drop procedure if EXISTS inserts;
create PROCEDURE inserts(in param int)
begin
while param < 2 do
insert into systemuser select replace(UUID(), '-', '') AS SYSTEMUSERGUID, concat(USERNAME, '_',param) AS USERNAME, LOGINNAME ,
PASSWORD , NICKNAME ,
SEX , SERIAL ,
ISENABLED , ORDERNO ,
NATIONALITY , BIRTHPLACE ,
MARITAL , POLITICS ,
SCHOOL , PROFESSION ,
BIRTHDATE , IDCARD ,
PHOTOSURL , RANKID ,
ZHICHENGID , POSITIONID ,
STATE , PHONE ,
MOBILE , EMAIL ,
POSTCODE , ADDRESS ,
SAFEPATH , CREATETIME ,
REMARK , CERTIFYMESSAGE ,
WRONGPASSCOUNT , SIGNIMG
from systemuser where LOGINNAME = 'wzl' ;
set param = param +1;
end while;
end;
SET @param = 0;
call inserts(@param);