How to Fill a table with data without a stored procedure/function?
<p>The goal is to create and populate a table with MySQL on the server. The table will be populated with 500 randomly selected names, addresses, and emails.</p>

<p>I created a procedure to complete this task, but it seems that my account does not have the permissions necessary to create stored procedures/functions, which is what every example I can find uses.</p>

<p>When I execute the file I get the following error:</p>

<p>ERROR 10444 (42000): Access denied for user 'username'@'localhost' to database 'db_name'</p>

<p>The file does create the table, it just doesn't get populated. 
How can I modify my code so that I don't need a stored procedure?</p>

<pre><code>use dbName;

drop table contacts;

create table dbName.contacts(
uid int(4) unsigned auto_increment primary key,
fname varchar(255),
lname varchar(255),
address varchar(255),
st varchar(2),
zipc int(5),
pNum int(10),
email varchar(255)
);

DELIMITER ##
create procedure fill_contacts_table()
begin

DECLARE counter INT;
SET counter = 0;

    while counter &lt; 500 do

            insert into contacts(
                fname,
                lname,
                address,
                st,
                zipc,
                pNum,
                email) 
            VALUES(
            ELT(1 + FLOOR(RAND()*100),
                'Willodean', 
                'Florentino',
                'Gale',  
                'Tasia', 
                'Bruno',  
                'Shanice',  
                'Chun',  
                'Moses',  
                'Fritz',  
                'Lincoln',  
                'Jeremy',  
                'Millie',  
                'Lorita',  
                'Quinn',  
                'Tennie',  
                'Gretchen',  
                'Mallory',  
                'Adolph',  
                'Jolene',  
                'Margarete',  
                'Charmaine',  
                'Pandora',  
                'Stephnie',  
                'Zelma',  
                'Vena',  
                'Joan',  
                'Berniece',  
                'Leonida',  
                'Sunni',  
                'Tonda',  
                'Keena',  
                'Evalyn',  
                'Kaylene',  
                'Rubie',  
                'Elia',  
                'Lorrine',  
                'Stasia',  
                'Loura',  
                'Rosie',  
                'Fredricka',  
                'Shawn',  
                'Felipa',  
                'Carmel',  
                'Kay',  
                'Ashanti',  
                'Helga',  
                'Charlotte',  
                'Hisako',  
                'Cheyenne ', 
                'Rudy',
                'Pearline', 
                'Isabelle',  
                'Hillary',  
                'Janett',  
                'Freddy',  
                'Kristyn',  
                'Karine',  
                'Delana',  
                'George',  
                'Marianela',  
                'Laurine',  
                'Clarissa',  
                'Han',  
                'Genny', 
                'Melita',  
                'Donette',  
                'Callie',  
                'Lavelle',  
                'Sharonda',  
                'Kirsten',  
                'Joanna',  
                'Muriel',  
                'Sherwood',  
                'Rebbeca',  
                'Jonah',  
                'Ellie',  
                'Marita',  
                'Fumiko',  
                'Gretchen',  
                'Stanford',  
                'Cecilia',  
                'Audry',  
                'Jermaine', 
                'Stephane',  
                'Cathleen',  
                'Neida',  
                'Reynaldo',  
                'Evelin',  
                'Irving',  
                'Sherril',  
                'Prudence',  
                'Karri',  
                'Berta',  
                'Valeri',  
                'Alyson',  
                'Tommy',  
                'Reina',  
                'Caren', 
                'Yon',  
                'Tereasa'),
            ELT(1 + FLOOR(RAND()*100),
                'Ress',
                'Dusek',
                'Eilers',
                'Brasch',
                'Ascencio',
                'Marti',
                'Glaze',
                'Pardon',
                'Alleman',
                'Cichon',
                'Weaver',
                'Clifford',
                'Herring',
                'Shoe',
                'Rey',
                'Mccay',
                'Mohl',
                'Mayo',
                'Romberger',
                'Dutta',
                'Tindal',
                'Clarkson',
                'Hellyer',
                'Albaugh',
                'Barfield',
                'Bazan',
                'Doubleday',
                'Freudenthal',
                'Motton',
                'Bertram',
                'Wisneski',
                'Luongo',
                'Maddocks',
                'Mcwilliam',
                'Debord',
                'Goldner',
                'Barham',
                'Cogley',
                'Maria',
                'Harms',
                'Parmer', 
                'Irion',
                'Carmean',
                'Nilson',
                'Corrao',
                'Giesler',
                'Winkel',
                'Jepson',
                'Kean',
                'Viens',
                'Rhett',
                'Feather',
                'Sonnier',
                'Newland', 
                'Lachermeier', 
                'Counter', 
                'Scharf', 
                'Barrentine', 
                'Reising', 
                'Kenny',
                'Jett', 
                'Deshong', 
                'Amico', 
                'Kieser', 
                'Kinsey',
                'Yun', 
                'Rohloff', 
                'Farinas', 
                'Abshire', 
                'Jefferson',
                'Forbis', 
                'Fortune', 
                'Osbourn', 
                'Siguenza', 
                'Davilla', 
                'Mcelhannon', 
                'Taniguchi', 
                'Spiegel', 
                'Karst', 
                'Polito', 
                'Montijo', 
                'Ager', 
                'Gee', 
                'Clutter', 
                'Stgeorge', 
                'Masterson', 
                'Inglis', 
                'Riemann',
                'Auxier', 
                'Charest', 
                'Westbrook', 
                'Bensen', 
                'Kotek', 
                'Mullens', 
                'Chatterton', 
                'Oommen', 
                'Delia', 
                'Jack', 
                'Zahm', 
                'Pfau'),
            ELT(1 + FLOOR(RAND()*100),
                '104 Green Court',
                '195 Central St.',
                '93 Race Road',
                '643 Penn St.',
                '75 Country Club Ave.',
                '328 North Warren Drive',
                '29 Bridgeton Street',
                '981 Virginia St.',
                '47 Snake Hill Ave.',
                '9784 Broad St.',
                '279 Livingston Drive',
                '555 Orange Street',
                '37 Summer Dr.',
                '95 Prairie St.', 
                '37 Fairground St.', 
                '965 Heather Avenue', 
                '290 Division St.', 
                '372 Plumb Branch St.', 
                '690 Ramblewood St.', 
                '40 Fremont Court', 
                '337C Alton Court', 
                '315 Alderwood St.', 
                '47 Mill Pond Drive', 
                '9815 Santa Clara Court', 
                '9 Fulton Ave.', 
                '960 Bradford Rd.', 
                '61 Peg Shop Dr.', 
                '810 South Dr.', 
                '6 NE. Cardinal Dr.', 
                '7438 Bishop Street', 
                '631 North Gulf Ave.', 
                '94 Clark St.', 
                '60 Williams Dr.', 
                '342 High Ridge Drive', 
                '9703 Gonzales Lane', 
                '9127 Alton Road', 
                '97 Maiden Drive', 
                '387 Lafayette Avenue', 
                '8688 Glen Eagles Avenue', 
                '7057 Sherman Street', 
                '7813 Pierce St.', 
                '83 Woodsman Lane', 
                '7238 West Laurel Ave.', 
                '553 Tunnel Court', 
                '8825 Del Monte St.', 
                '984 East Orchard Drive', 
                '88 Princess St.', 
                '40 E. Wakehurst Lane', 
                '8893 Glenlake Dr.', 
                '4 School Rd.', 
                '7239 SE. Thompson Lane', 
                '627 Warren Ave.',
                '595 Purple Finch Street', 
                '8194 Valley View St.', 
                '259B Randall Mill Ave.', 
                '9460 Spring St.', 
                '9810 Henry Street', 
                '203 E. Eagle Circle', 
                '9582 South Charles Lane', 
                '40 Brewery Ave.', 
                '19 Fulton St.', 
                '340 Edgewater St.', 
                '330 Golden Star Drive', 
                '616 Lexington Ave.', 
                '2 S. Peg Shop St.', 
                '8845 Sutor Rd.', 
                '9919 Southampton Ave.', 
                '50 E. University Ave.', 
                '200 Ryan Ave.', 
                '38 Walnutwood Road', 
                '81 East Victoria Dr.', 
                '6 S. Rocky River Rd.', 
                '549 Princeton Court', 
                '9777 Sherman St.', 
                '7073 Main Street', 
                '406 Queen Dr.', 
                '874 Squaw Creek St.', 
                '9 W. Rose St.', 
                '27 6th Ave.', 
                '135 Cobblestone St.', 
                '531 La Sierra Avenue', 
                '253 East Fawn Ave.', 
                '17 SW. Hillside St.', 
                '5 Tower St.', 
                '69 Smith Court', 
                '395 Foster St.', 
                '20 Race Lane', 
                '9073 Wagon Dr.',
                '20 Fawn Dr.', 
                '195 Central St.', 
                '14 S. Cambridge St.', 
                '535 Griffin Street', 
                '643 Penn Street', 
                '19 Cemetery Dr.', 
                '75 Country Club Ave.', 
                '439 Military Rd.', 
                '285 Philmont Court', 
                '405 Valley View St.', 
                '8662 Magnolia Dr.', 
                '7781 Country Club St.'),
            ELT(1 + FLOOR(RAND()*51),
                'AL',
                'AK',
                'AZ',
                'AR',
                'CA',
                'CO',
                'CT',
                'DE',
                'FL',
                'GA',
                'HI',
                'ID',
                'IL',
                'IN',
                'IA',
                'KS',
                'KY',
                'LA',
                'ME',
                'MD',
                'MA',
                'MI',
                'MN',
                'MS',
                'MO',
                'MT',
                'NE',
                'NV',
                'NH',
                'NJ',
                'NM',
                'NY',
                'NC',
                'ND',
                'OH',
                'OK',
                'OR',
                'PA',
                'RI',
                'SC',
                'SD',
                'TN',
                'TX',
                'UT',
                'VT',
                'VA',
                'WA',
                'WV',
                'WI',
                'WY',
                'DC'),
            ELT(1 + FLOOR(RAND()*100),
                '11720',
                '44133',
                '39564',
                '07103',
                '41018',
                '45211',
                '34711',
                '33904',
                '08021',
                '45040',
                '12401',
                '20715',
                '45103',
                '19038',
                '32303',
                '32958',
                '19468',
                '85302',
                '37076',
                '48021',
                '43512',
                '08060',
                '15206',
                '07840',
                '33139',
                '30040',
                '27529',
                '48101',
                '85224',
                '71730',
                '53066',
                '19454',
                '02072',
                '02127',
                '32904',
                '44145',
                '83651',
                '30126',
                '11572',
                '60101',
                '20874',
                '20707',
                '68107',
                '30294',
                '11552',
                '48310',
                '07080',
                '32955',
                '01845',
                '02155',
                '04106',
                '08540',
                '06484',
                '60435',
                '45066',
                '32707',
                '16601',
                '21771',
                '52501',
                '22304',
                '60451',
                '60466',
                '56401',
                '08857',
                '50310',
                '55316',
                '21009',
                '46304',
                '02131',
                '29646',
                '37849',
                '33702',
                '48178',
                '28655',
                '08520',
                '53051',
                '74820',
                '11417',
                '55343',
                '13501',
                '02148',
                '22041',
                '34787',
                '18015',
                '11701',
                '48067',
                '32003',
                '32250',
                '07666',
                '01801',
                '26508',
                '06492',
                '37072',
                '44266',
                '20832',
                '55330',
                '20705',
                '60133',
                '37388',
                '30188'),
            ELT(1 + FLOOR(RAND()*100),
                '5326650789',
                '5458797497',
                '3969507190',
                '7899779099',
                '5737791024',
                '7152078410',
                '1585609748',
                '9114083701',
                '3319518922',
                '4097559835',
                '7795824751',
                '8152827507',
                '4932036403',
                '6402549987',
                '4342372370',
                '1818285402',
                '7764560114',
                '5052529831',
                '5638654168',
                '5533069282',
                '4588207833',
                '9772641803',
                '2105777477',
                '5487138355',
                '8157763224',
                '6076582385',
                '3091969824',
                '4599611212',
                '1622356799',
                '2193172740',
                '3802198191',
                '8874918768',
                '3527695220',
                '1468081570',
                '8781101437',
                '1783794554',
                '4147642090',
                '6946664816',
                '5259058695',
                '1915347568',
                '7271267139',
                '6915931769',
                '6009627523',
                '9326664619',
                '5669870035',
                '8502271545',
                '9069278491',
                '3309903311',
                '6764406845',
                '9709978941',
                '4967657222',
                '6681379186',
                '6876692503',
                '9115377994',
                '4152903971',
                '3221536656',
                '6531287939',
                '1333154307',
                '1989681996',
                '9823062288',
                '4941263197',
                '8242856770',
                '4085259464',
                '5644693994',
                '2471816666',
                '7743998254',
                '4384095056',
                '8761651796',
                '6535832572',
                '6411644955',
                '9128111230',
                '6084608842',
                '3385174240',
                '2605959727',
                '5443426087',
                '6625356226',
                '4048849246',
                '3775164894',
                '6278296182',
                '3357967793',
                '9195838006',
                '5634927312',
                '7928037269',
                '1512947086',
                '2287557623',
                '1797525964',
                '2979326380',
                '9379217217',
                '8984965224',
                '6219840588',
                '2308367597',
                '6971476470',
                '2085510840',
                '7069816501',
                '2994249472',
                '7672890630',
                '4708647664',
                '9064472436',
                '7391029735',
                '2793660389'),
            ELT(1 + FLOOR(RAND()*500),
                'myemail.1@e.mail',
                'myemail.2@e.mail',
                'myemail.3@e.mail',
                'myemail.4@e.mail',
                'myemail.5@e.mail',
                'myemail.6@e.mail',
                'myemail.7@e.mail',
                'myemail.8@e.mail',
                'myemail.9@e.mail',
                'myemail.10@e.mail',
                'myemail.11@e.mail',
                'myemail.12@e.mail',
                'myemail.13@e.mail',
                'myemail.14@e.mail',
                'myemail.15@e.mail',
                'myemail.16@e.mail',
                'myemail.17@e.mail',
                'myemail.18@e.mail',
                'myemail.19@e.mail',
                'myemail.20@e.mail',
                'myemail.21@e.mail',
                'myemail.22@e.mail',
                'myemail.23@e.mail',
                'myemail.24@e.mail',
                'myemail.25@e.mail',
                'myemail.26@e.mail',
                'myemail.27@e.mail',
                'myemail.28@e.mail',
                'myemail.29@e.mail',
                'myemail.30@e.mail',
                'myemail.31@e.mail',
                'myemail.32@e.mail',
                'myemail.33@e.mail',
                'myemail.34@e.mail',
                'myemail.35@e.mail',
                'myemail.36@e.mail',
                'myemail.37@e.mail',
                'myemail.38@e.mail',
                'myemail.39@e.mail',
                'myemail.40@e.mail',
                'myemail.41@e.mail',
                'myemail.42@e.mail',
                'myemail.43@e.mail',
                'myemail.44@e.mail',
                'myemail.45@e.mail',
                'myemail.46@e.mail',
                'myemail.47@e.mail',
                'myemail.48@e.mail',
                'myemail.49@e.mail',
                'myemail.50@e.mail',
                'myemail.51@e.mail',
                'myemail.52@e.mail',
                'myemail.53@e.mail',
                'myemail.54@e.mail',
                'myemail.55@e.mail',
                'myemail.56@e.mail',
                'myemail.57@e.mail',
                'myemail.58@e.mail',
                'myemail.59@e.mail',
                'myemail.60@e.mail',
                'myemail.61@e.mail',
                'myemail.62@e.mail',
                'myemail.63@e.mail',
                'myemail.64@e.mail',
                'myemail.65@e.mail',
                'myemail.66@e.mail',
                'myemail.67@e.mail',
                'myemail.69@e.mail',
                'myemail.69@e.mail',
                'myemail.70@e.mail',
                'myemail.71@e.mail',
                'myemail.72@e.mail',
                'myemail.73@e.mail',
                'myemail.74@e.mail',
                'myemail.75@e.mail',
                'myemail.76@e.mail',
                'myemail.77@e.mail',
                'myemail.78@e.mail',
                'myemail.79@e.mail',
                'myemail.80@e.mail',
                'myemail.81@e.mail',
                'myemail.82@e.mail',
                'myemail.83@e.mail',
                'myemail.84@e.mail',
                'myemail.85@e.mail',
                'myemail.86@e.mail',
                'myemail.87@e.mail',
                'myemail.88@e.mail',
                'myemail.89@e.mail',
                'myemail.90@e.mail',
                'myemail.91@e.mail',
                'myemail.92@e.mail',
                'myemail.93@e.mail',
                'myemail.94@e.mail',
                'myemail.95@e.mail',
                'myemail.96@e.mail',
                'myemail.97@e.mail',
                'myemail.98@e.mail',
                'myemail.99@e.mail',
                'myemail.100@e.mail',
                'myemail.101@e.mail',
                'myemail.102@e.mail',
                'myemail.103@e.mail',
                'myemail.104@e.mail',
                'myemail.105@e.mail',
                'myemail.106@e.mail',
                'myemail.107@e.mail',
                'myemail.108@e.mail',
                'myemail.109@e.mail',
                'myemail.110@e.mail',
                'myemail.111@e.mail',
                'myemail.112@e.mail',
                'myemail.113@e.mail',
                'myemail.114@e.mail',
                'myemail.115@e.mail',
                'myemail.116@e.mail',
                'myemail.117@e.mail',
                'myemail.118@e.mail',
                'myemail.119@e.mail',
                'myemail.120@e.mail',
                'myemail.121@e.mail',
                'myemail.122@e.mail',
                'myemail.123@e.mail',
                'myemail.124@e.mail',
                'myemail.125@e.mail',
                'myemail.126@e.mail',
                'myemail.127@e.mail',
                'myemail.128@e.mail',
                'myemail.129@e.mail',
                'myemail.130@e.mail',
                'myemail.131@e.mail',
                'myemail.132@e.mail',
                'myemail.133@e.mail',
                'myemail.134@e.mail',
                'myemail.135@e.mail',
                'myemail.136@e.mail',
                'myemail.137@e.mail',
                'myemail.138@e.mail',
                'myemail.139@e.mail',
                'myemail.140@e.mail',
                'myemail.141@e.mail',
                'myemail.142@e.mail',
                'myemail.143@e.mail',
                'myemail.144@e.mail',
                'myemail.145@e.mail',
                'myemail.146@e.mail',
                'myemail.147@e.mail',
                'myemail.148@e.mail',
                'myemail.149@e.mail',
                'myemail.150@e.mail',
                'myemail.151@e.mail',
                'myemail.152@e.mail',
                'myemail.153@e.mail',
                'myemail.154@e.mail',
                'myemail.155@e.mail',
                'myemail.156@e.mail',
                'myemail.157@e.mail',
                'myemail.158@e.mail',
                'myemail.159@e.mail',
                'myemail.160@e.mail',
                'myemail.161@e.mail',
                'myemail.162@e.mail',
                'myemail.163@e.mail',
                'myemail.164@e.mail',
                'myemail.165@e.mail',
                'myemail.166@e.mail',
                'myemail.167@e.mail',
                'myemail.168@e.mail',
                'myemail.169@e.mail',
                'myemail.170@e.mail',
                'myemail.171@e.mail',
                'myemail.172@e.mail',
                'myemail.173@e.mail',
                'myemail.174@e.mail',
                'myemail.175@e.mail',
                'myemail.176@e.mail',
                'myemail.177@e.mail',
                'myemail.178@e.mail',
                'myemail.179@e.mail',
                'myemail.180@e.mail',
                'myemail.181@e.mail',
                'myemail.182@e.mail',
                'myemail.183@e.mail',
                'myemail.184@e.mail',
                'myemail.185@e.mail',
                'myemail.186@e.mail',
                'myemail.187@e.mail',
                'myemail.188@e.mail',
                'myemail.189@e.mail',
                'myemail.190@e.mail',
                'myemail.191@e.mail',
                'myemail.192@e.mail',
                'myemail.193@e.mail',
                'myemail.194@e.mail',
                'myemail.195@e.mail',
                'myemail.196@e.mail',
                'myemail.197@e.mail',
                'myemail.198@e.mail',
                'myemail.199@e.mail',
                'myemail.200@e.mail',
                'myemail.201@e.mail',
                'myemail.202@e.mail',
                'myemail.203@e.mail',
                'myemail.204@e.mail',
                'myemail.205@e.mail',
                'myemail.206@e.mail',
                'myemail.207@e.mail',
                'myemail.208@e.mail',
                'myemail.209@e.mail',
                'myemail.210@e.mail',
                'myemail.211@e.mail',
                'myemail.212@e.mail',
                'myemail.213@e.mail',
                'myemail.214@e.mail',
                'myemail.215@e.mail',
                'myemail.216@e.mail',
                'myemail.217@e.mail',
                'myemail.218@e.mail',
                'myemail.219@e.mail',
                'myemail.220@e.mail',
                'myemail.221@e.mail',
                'myemail.222@e.mail',
                'myemail.223@e.mail',
                'myemail.224@e.mail',
                'myemail.225@e.mail',
                'myemail.226@e.mail',
                'myemail.227@e.mail',
                'myemail.228@e.mail',
                'myemail.229@e.mail',
                'myemail.230@e.mail',
                'myemail.231@e.mail',
                'myemail.232@e.mail',
                'myemail.233@e.mail',
                'myemail.234@e.mail',
                'myemail.235@e.mail',
                'myemail.236@e.mail',
                'myemail.237@e.mail',
                'myemail.238@e.mail',
                'myemail.239@e.mail',
                'myemail.240@e.mail',
                'myemail.241@e.mail',
                'myemail.242@e.mail',
                'myemail.243@e.mail',
                'myemail.244@e.mail',
                'myemail.245@e.mail',
                'myemail.246@e.mail',
                'myemail.247@e.mail',
                'myemail.248@e.mail',
                'myemail.249@e.mail',
                'myemail.250@e.mail',
                'myemail.251@e.mail',
                'myemail.252@e.mail',
                'myemail.253@e.mail',
                'myemail.254@e.mail',
                'myemail.255@e.mail',
                'myemail.256@e.mail',
                'myemail.257@e.mail',
                'myemail.258@e.mail',
                'myemail.259@e.mail',
                'myemail.260@e.mail',
                'myemail.261@e.mail',
                'myemail.262@e.mail',
                'myemail.263@e.mail',
                'myemail.264@e.mail',
                'myemail.265@e.mail',
                'myemail.266@e.mail',
                'myemail.267@e.mail',
                'myemail.269@e.mail',
                'myemail.269@e.mail',
                'myemail.270@e.mail',
                'myemail.271@e.mail',
                'myemail.272@e.mail',
                'myemail.273@e.mail',
                'myemail.274@e.mail',
                'myemail.275@e.mail',
                'myemail.276@e.mail',
                'myemail.277@e.mail',
                'myemail.278@e.mail',
                'myemail.279@e.mail',
                'myemail.280@e.mail',
                'myemail.281@e.mail',
                'myemail.282@e.mail',
                'myemail.283@e.mail',
                'myemail.284@e.mail',
                'myemail.285@e.mail',
                'myemail.286@e.mail',
                'myemail.287@e.mail',
                'myemail.288@e.mail',
                'myemail.289@e.mail',
                'myemail.290@e.mail',
                'myemail.291@e.mail',
                'myemail.292@e.mail',
                'myemail.293@e.mail',
                'myemail.294@e.mail',
                'myemail.295@e.mail',
                'myemail.296@e.mail',
                'myemail.297@e.mail',
                'myemail.298@e.mail',
                'myemail.299@e.mail',
                'myemail.300@e.mail',
                'myemail.301@e.mail',
                'myemail.302@e.mail',
                'myemail.303@e.mail',
                'myemail.304@e.mail',
                'myemail.305@e.mail',
                'myemail.306@e.mail',
                'myemail.307@e.mail',
                'myemail.308@e.mail',
                'myemail.309@e.mail',
                'myemail.310@e.mail',
                'myemail.311@e.mail',
                'myemail.312@e.mail',
                'myemail.313@e.mail',
                'myemail.314@e.mail',
                'myemail.315@e.mail',
                'myemail.316@e.mail',
                'myemail.317@e.mail',
                'myemail.318@e.mail',
                'myemail.319@e.mail',
                'myemail.320@e.mail',
                'myemail.321@e.mail',
                'myemail.322@e.mail',
                'myemail.323@e.mail',
                'myemail.324@e.mail',
                'myemail.325@e.mail',
                'myemail.326@e.mail',
                'myemail.327@e.mail',
                'myemail.328@e.mail',
                'myemail.329@e.mail',
                'myemail.330@e.mail',
                'myemail.331@e.mail',
                'myemail.332@e.mail',
                'myemail.333@e.mail',
                'myemail.334@e.mail',
                'myemail.335@e.mail',
                'myemail.336@e.mail',
                'myemail.337@e.mail',
                'myemail.338@e.mail',
                'myemail.339@e.mail',
                'myemail.340@e.mail',
                'myemail.341@e.mail',
                'myemail.342@e.mail',
                'myemail.343@e.mail',
                'myemail.344@e.mail',
                'myemail.345@e.mail',
                'myemail.346@e.mail',
                'myemail.347@e.mail',
                'myemail.348@e.mail',
                'myemail.349@e.mail',
                'myemail.350@e.mail',
                'myemail.351@e.mail',
                'myemail.352@e.mail',
                'myemail.353@e.mail',
                'myemail.354@e.mail',
                'myemail.355@e.mail',
                'myemail.356@e.mail',
                'myemail.357@e.mail',
                'myemail.358@e.mail',
                'myemail.359@e.mail',
                'myemail.360@e.mail',
                'myemail.361@e.mail',
                'myemail.362@e.mail',
                'myemail.363@e.mail',
                'myemail.364@e.mail',
                'myemail.365@e.mail',
                'myemail.366@e.mail',
                'myemail.367@e.mail',
                'myemail.369@e.mail',
                'myemail.369@e.mail',
                'myemail.370@e.mail',
                'myemail.371@e.mail',
                'myemail.372@e.mail',
                'myemail.373@e.mail',
                'myemail.374@e.mail',
                'myemail.375@e.mail',
                'myemail.376@e.mail',
                'myemail.377@e.mail',
                'myemail.378@e.mail',
                'myemail.379@e.mail',
                'myemail.380@e.mail',
                'myemail.381@e.mail',
                'myemail.382@e.mail',
                'myemail.383@e.mail',
                'myemail.384@e.mail',
                'myemail.385@e.mail',
                'myemail.386@e.mail',
                'myemail.387@e.mail',
                'myemail.388@e.mail',
                'myemail.389@e.mail',
                'myemail.390@e.mail',
                'myemail.391@e.mail',
                'myemail.392@e.mail',
                'myemail.393@e.mail',
                'myemail.394@e.mail',
                'myemail.395@e.mail',
                'myemail.396@e.mail',
                'myemail.397@e.mail',
                'myemail.398@e.mail',
                'myemail.399@e.mail',
                'myemail.400@e.mail',
                'myemail.401@e.mail',
                'myemail.402@e.mail',
                'myemail.403@e.mail',
                'myemail.404@e.mail',
                'myemail.405@e.mail',
                'myemail.406@e.mail',
                'myemail.407@e.mail',
                'myemail.408@e.mail',
                'myemail.409@e.mail',
                'myemail.410@e.mail',
                'myemail.411@e.mail',
                'myemail.412@e.mail',
                'myemail.413@e.mail',
                'myemail.414@e.mail',
                'myemail.415@e.mail',
                'myemail.416@e.mail',
                'myemail.417@e.mail',
                'myemail.418@e.mail',
                'myemail.419@e.mail',
                'myemail.420@e.mail',
                'myemail.421@e.mail',
                'myemail.422@e.mail',
                'myemail.423@e.mail',
                'myemail.424@e.mail',
                'myemail.425@e.mail',
                'myemail.426@e.mail',
                'myemail.427@e.mail',
                'myemail.428@e.mail',
                'myemail.429@e.mail',
                'myemail.430@e.mail',
                'myemail.431@e.mail',
                'myemail.432@e.mail',
                'myemail.433@e.mail',
                'myemail.434@e.mail',
                'myemail.435@e.mail',
                'myemail.436@e.mail',
                'myemail.437@e.mail',
                'myemail.438@e.mail',
                'myemail.439@e.mail',
                'myemail.440@e.mail',
                'myemail.441@e.mail',
                'myemail.442@e.mail',
                'myemail.443@e.mail',
                'myemail.444@e.mail',
                'myemail.445@e.mail',
                'myemail.446@e.mail',
                'myemail.447@e.mail',
                'myemail.448@e.mail',
                'myemail.449@e.mail',
                'myemail.450@e.mail',
                'myemail.451@e.mail',
                'myemail.452@e.mail',
                'myemail.453@e.mail',
                'myemail.454@e.mail',
                'myemail.455@e.mail',
                'myemail.456@e.mail',
                'myemail.457@e.mail',
                'myemail.458@e.mail',
                'myemail.459@e.mail',
                'myemail.460@e.mail',
                'myemail.461@e.mail',
                'myemail.462@e.mail',
                'myemail.463@e.mail',
                'myemail.464@e.mail',
                'myemail.465@e.mail',
                'myemail.466@e.mail',
                'myemail.467@e.mail',
                'myemail.469@e.mail',
                'myemail.469@e.mail',
                'myemail.470@e.mail',
                'myemail.471@e.mail',
                'myemail.472@e.mail',
                'myemail.473@e.mail',
                'myemail.474@e.mail',
                'myemail.475@e.mail',
                'myemail.476@e.mail',
                'myemail.477@e.mail',
                'myemail.478@e.mail',
                'myemail.479@e.mail',
                'myemail.480@e.mail',
                'myemail.481@e.mail',
                'myemail.482@e.mail',
                'myemail.483@e.mail',
                'myemail.484@e.mail',
                'myemail.485@e.mail',
                'myemail.486@e.mail',
                'myemail.487@e.mail',
                'myemail.488@e.mail',
                'myemail.489@e.mail',
                'myemail.490@e.mail',
                'myemail.491@e.mail',
                'myemail.492@e.mail',
                'myemail.493@e.mail',
                'myemail.494@e.mail',
                'myemail.495@e.mail',
                'myemail.496@e.mail',
                'myemail.497@e.mail',
                'myemail.498@e.mail',
                'myemail.499@e.mail',
                'myemail.500@e.mail')
            );
            SET counter = counter + 1;
    end while;

end##
DELIMITER ;
</code></pre>