
insert into gemeente (naam,postcode) values ("Brussel","1070");
insert into stadion (naam,capaciteit,straat,nummer,gemeenteid) values ("Constant Vanden Stock-stadion","26361","Theo Verbeeklaan","2",(select LAST_INSERT_ID()));
insert into ploeg (id,naam,clubkleuren,logo,website,stadionid) values ("AND","RSC Anderlecht","Paars-Wit","anderlecht.jpg","www.rsca.be",(select LAST_INSERT_ID()));

insert into gemeente (naam,postcode) values ("Brugge","8200");
insert into stadion (naam,capaciteit,straat,nummer,gemeenteid) values ("Jan Breydelstadion","29042","Olympialaan","74",(select LAST_INSERT_ID()));
insert into ploeg (id,naam,clubkleuren,logo,website,stadionid) values ("CER","Cercle Brugge","Groen-Zwart","cercle.jpg","www.cerclebrugge.be",(select LAST_INSERT_ID()));

insert into gemeente (naam,postcode) values ("Charleroi","6000");
insert into stadion (naam,capaciteit,straat,nummer,gemeenteid) values ("Stade du Pays de Charleroi","24891","Boulevard Zoé Drion","19",(select LAST_INSERT_ID()));
insert into ploeg (id,naam,clubkleuren,logo,website,stadionid) values ("CHA","Sporting Charleroi","Zwart-Wit","charleroi.jpg","www.sporting-charleroi.be",(select LAST_INSERT_ID()));

insert into gemeente (naam,postcode) values ("Brugge","8200");
insert into stadion (naam,capaciteit,straat,nummer,gemeenteid) values ("Jan Breydelstadion","29042","Olympialaan","74",(select LAST_INSERT_ID()));
insert into ploeg (id,naam,clubkleuren,logo,website,stadionid) values ("CLU","Club Brugge","Blauw-Zwart","club.jpg","www.clubbrugge.be",(select LAST_INSERT_ID()));

insert into gemeente (naam,postcode) values ("Genk","3600");
insert into stadion (naam,capaciteit,straat,nummer,gemeenteid) values ("Cristal Arena","24604","Stadionplein","4",(select LAST_INSERT_ID()));
insert into ploeg (id,naam,clubkleuren,logo,website,stadionid) values ("GNK","Racing Genk","Blauw-Wit","genk.jpg","www.krcgenk.be",(select LAST_INSERT_ID()));

insert into gemeente (naam,postcode) values ("Gentbrugge","9050");
insert into stadion (naam,capaciteit,straat,nummer,gemeenteid) values ("Jules Ottenstadion","12919","Bruiloftstraat","42",(select LAST_INSERT_ID()));
insert into ploeg (id,naam,clubkleuren,logo,website,stadionid) values ("GNT","AA Gent","Blauw-Wit","gent.jpg","www.kaagent.be",(select LAST_INSERT_ID()));

insert into gemeente (naam,postcode) values ("Antwerpen","2020");
insert into stadion (naam,capaciteit,straat,nummer,gemeenteid) values ("Olympisch Stadion","12770","Atletenstraat","80",(select LAST_INSERT_ID()));
insert into ploeg (id,naam,clubkleuren,logo,website,stadionid) values ("GBA","Germinal Beerschot","Paars-Geel","gba.jpg","www.germinal-beerschot.be",(select LAST_INSERT_ID()));

insert into gemeente (naam,postcode) values ("Kortrijk","8500");
insert into stadion (naam,capaciteit,straat,nummer,gemeenteid) values ("Guldensporenstadion","9399","Meensesteenweg","84",(select LAST_INSERT_ID()));
insert into ploeg (id,naam,clubkleuren,logo,website,stadionid) values ("KOR","KV Kortrijk","Rood-Wit","kortrijk.jpg","www.kvkortrijk.be",(select LAST_INSERT_ID()));

insert into gemeente (naam,postcode) values ("Lokeren","9160");
insert into stadion (naam,capaciteit,straat,nummer,gemeenteid) values ("Daknamstadion","9560","Daknamstraat","91",(select LAST_INSERT_ID()));
insert into ploeg (id,naam,clubkleuren,logo,website,stadionid) values ("LOK","Lokeren","Zwart-Geel-Wit","lokeren.jpg","www.sporting.be",(select LAST_INSERT_ID()));

insert into gemeente (naam,postcode) values ("Mechelen","2800");
insert into stadion (naam,capaciteit,straat,nummer,gemeenteid) values ("Achter de Kazerne","13123","Kleine Nieuwendijk","53",(select LAST_INSERT_ID()));
insert into ploeg (id,naam,clubkleuren,logo,website,stadionid) values ("KVM","KV Mechelen","Geel-Rood","mechelen.jpg","www.kvmechelen.be",(select LAST_INSERT_ID()));

insert into gemeente (naam,postcode) values ("Moeskroen","7700");
insert into stadion (naam,capaciteit,straat,nummer,gemeenteid) values ("Le Canonnier","10571","Rue du Stade","33",(select LAST_INSERT_ID()));
insert into ploeg (id,naam,clubkleuren,logo,website,stadionid) values ("MOE","Moeskroen","Rood-Wit","moeskroen.jpg","www.excelsior.be",(select LAST_INSERT_ID()));

insert into gemeente (naam,postcode) values ("Roeselare","8800");
insert into stadion (naam,capaciteit,straat,nummer,gemeenteid) values ("Schierveldestadion","9653","Dikmuidsesteenweg","374",(select LAST_INSERT_ID()));
insert into ploeg (id,naam,clubkleuren,logo,website,stadionid) values ("ROE","Roeselare","Zwart-Wit","roeselare.jpg","www.ksvroeselare.be",(select LAST_INSERT_ID()));

insert into gemeente (naam,postcode) values ("Sint-Truiden","3800");
insert into stadion (naam,capaciteit,straat,nummer,gemeenteid) values ("Staaien","12100","Tiensesteenweg","223",(select LAST_INSERT_ID()));
insert into ploeg (id,naam,clubkleuren,logo,website,stadionid) values ("STVV","Sint-Truiden","Blauw-Geel","sinttruiden.jpg","www.stvv.com",(select LAST_INSERT_ID()));

insert into gemeente (naam,postcode) values ("Luik","4000");
insert into stadion (naam,capaciteit,straat,nummer,gemeenteid) values ("Maurice Dufrasne stadion","30023","Rue de la Centrale","2",(select LAST_INSERT_ID()));
insert into ploeg (id,naam,clubkleuren,logo,website,stadionid) values ("STA","Standard","Rood-Wit","standard.jpg","www.standardliege.be",(select LAST_INSERT_ID()));

insert into gemeente (naam,postcode) values ("Westerlo","2260");
insert into stadion (naam,capaciteit,straat,nummer,gemeenteid) values ("Het Kuipje","7982","De Merodedreef","189",(select LAST_INSERT_ID()));
insert into ploeg (id,naam,clubkleuren,logo,website,stadionid) values ("WES","Westerlo","Geel-Blauw","westerlo.jpg","www.kvcwesterlo.be",(select LAST_INSERT_ID()));

insert into gemeente (naam,postcode) values ("Waregem","9870");
insert into stadion (naam,capaciteit,straat,nummer,gemeenteid) values ("Regenboogstadion","8500","Kastanjelaan","75",(select LAST_INSERT_ID()));
insert into ploeg (id,naam,clubkleuren,logo,website,stadionid) values ("ZWA","Zulte Waregem","Groen-Rood","zulte.jpg","www.svzw.be",(select LAST_INSERT_ID()));
