mysql生产11位随机数_mysql 用存储过程插入11位 随机数

BEGIN

#Routine body goes here...

DECLARE rowid INT DEFAULT 0;

DECLARE firstname CHAR(1);

DECLARE name1 CHAR(1);

DECLARE name2 CHAR(1);

DECLARE name3 CHAR(1);

DECLARE name4 CHAR(1);

DECLARE name5 CHAR(1);

DECLARE name6 CHAR(1);

DECLARE name7 CHAR(1);

DECLARE name8 CHAR(1);

DECLARE name9 CHAR(1);

DECLARE name10 CHAR(1);

DECLARE name11 CHAR(1);

DECLARE lastname VARCHAR(11) DEFAULT '';

DECLARE sex CHAR(1);

DECLARE score CHAR(2);

WHILE rowid < num DO

SET name1 = SUBSTRING('wjgW5EaRedTYmU1tIcOsbPqfLx4KJQ2khHn9vGFz3Drlu76SAZ0XoCyVpB8NiM',ROUND(1+43*RAND()),1);

SET name2 = SUBSTRING('wjgW5EaRedTYmU1tIcOsbPqfLx4KJQ2khHn9vGFz3Drlu76SAZ0XoCyVpB8NiM',ROUND(1+43*RAND()),1);

SET name3 = SUBSTRING('wjgW5EaRedTYmU1tIcOsbPqfLx4KJQ2k