Personal backup-mysql Stored Procedure

/* Parameter: Start ID, customer ID, number of records, initial user name */
Delimiter $
Create procedure batchinsert (in init int, in CID int, in loops int, in username varchar (64 ))
Begin
Declare myid int;
Declare myname varchar (64 );
Declare num int;
Set myid = Init;
Set myname = username;
Set num = 1;
While num <= loops do
Set myname = Concat (username, convert (myid, char ));
/* Insert a user into the user table */
Insert into user (ID, CID, name, realname, photo, experience, register_date, modify_date)
Values (myid, CID, myname, myname, 'www .baidu.com ', 1200.00, now (), now ());
/* Insert the user's experience record into the experience table */
Insert into user_experience (CID, name, qid, aid, exp_reg, tags, create_date, modify_date, exp_status)
Values (CID, myname, 10000,100 00, 3.14, 'AB, CD, ee', now (), now (), 2 );
Set num = num + 1;
Set myid = myid + 1;
End while;
End $

Call batchinsert (5000, 'aaa ');
Call batchinsert (5000, 'bbb ');