Add sample customers to customers db table in mysql

add_sample_customers_data.sql

drop procedure if exists populate_customers;
delimiter //
create procedure populate_customers (in num int)
begin
declare i int default 0;
while i < num do
insert into customers (customer_id, name, email) values ((num*10)+i, concat('name', i), concat('email', i));
set i = i + 1;
end while;
end //
delimiter ;

call populate_customers (500000);