mysql 存储过程海量数据写入和查询

01:06:07.22   循环插入10万条数据 


 00:13.97   sql拼接 批量插入10万条数据
 
 22:13.39 sql拼接 批量插入1000万条数据

BEGIN

DECLARE i int;
DECLARE j int;
DECLARE str VARCHAR(65535);
SET i = 0;
WHILE i < 10000 DO
		SET j = 0;
		SET i = i + 1;
		SET str = '';
		WHILE j < 1000 DO
			SET j = j + 1;
			SET str = CONCAT(str,',(',rand() * 10000,')');
		END WHILE;
		set str = SUBSTRING(str, 2);
		set @exesql = concat("insert into `all_user` (`username`) values ", str);
		prepare stmt from @exesql;
		execute stmt;
		DEALLOCATE prepare stmt;
END WHILE;


END

　　http://blog.csdn.net/xiakepan/article/details/52703189