随机创建数据sql

SET @charset = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';
DELIMITER //
CREATE PROCEDURE myProcedure () BEGIN
	DECLARE
		counter INT DEFAULT 0;
	WHILE
			counter < 1000000 DO
			INSERT INTO demo.demo ( `name`, nickname ) 
			SELECT
				nickname,
				REVERSE( nickname ) AS nickname2 
			FROM
				( SELECT CONCAT( "测试", SUBSTRING( @charset, FLOOR( RAND() * LENGTH( @charset ) + 1 ), 3 )) AS nickname ) AS subquery;
				SET counter = counter + 1;
				
		END WHILE;
	
END // 
DELIMITER;

call myProcedure()