MySQL 테스트 데이터복제

 
set @rownum := 0;

insert into indextest 
select s.*
from (
		select @rownum = @rownum + 1 rownum,  customer_id,  inventory_id, rental_date, last_update, 0, staff_id 
		from sakila.rental ) s , (select 1 from performance_schema.global_variables limit 10 ) v, (select @rownum := 0) temp 
limit 2000000        ;