创建角色随机名字（mysql抽取随机记录）和mysql游标的使用

BEGIN		
	DECLARE randnum int DEFAULT 0;
	SELECT FLOOR(RAND() * 309034) INTO randnum;
	SELECT rname INTO _name FROM `names` WHERE ((_sex = sex) AND
		(rname not in (SELECT Name FROM longwen.player WHERE _world = WorldID)) AND
		(id > randnum)) LIMIT 1;
		
	set returnvalue = 0;
END

DECLARE _cursor CURSOR FOR 
SELECT RoleID FROM player WHERE (RoleID NOT IN (SELECT roleID FROM email where LENGTH(datas) <> 0)); 
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' set _done = 1;

OPEN _cursor;  
set _done = 0;
REPEAT
	FETCH _cursor into _roleId;
	replace into email(roleID, datas) values(_roleId, 'test');
UNTIL _done END REPEAT;
CLOSE _cursor;