Large cities and towns from https://www.citypopulation.de/Europe.html
Regular expressions used in Notepad++ to speed up formatting data for my SELECT queries.
^ = beginning of new line

$ = end of line

These simple regular expressions easily allow the creation of the SQL statment from a list of places as follows:
# Spain
INSERT INTO euromajorcities SELECT country_code, city_name_ascii, latitude, longitude, timezoneid FROM eurocity WHERE country_code="ES" AND (
city_name_ascii="Madrid" OR
city_name_ascii="Barcelona" OR
city_name_ascii="València" OR
city_name_ascii="Sevilla" OR
city_name_ascii="Zaragoza" OR
city_name_ascii="Málaga" OR
city_name_ascii="Murcia" OR
city_name_ascii="Palma" OR
city_name_ascii="Las Palmas de Gran Canaria" OR
city_name_ascii="Bilbao");
The full query so far..
DROP TABLE IF EXISTS euromajorcities;
create table euromajorcities (country_code varchar(2), city_name_ascii varchar(255), latitude float DEFAULT 0, longitude float DEFAULT 0,timezoneid varchar(255));
ALTER TABLE euromajorcities CONVERT TO CHARACTER SET utf8 COLLATE utf8_persian_ci;
# France
INSERT INTO euromajorcities SELECT country_code, city_name_ascii, latitude, longitude, timezoneid FROM eurocity WHERE country_code="FR" AND (
city_name_ascii="Paris" OR
city_name_ascii="Marseille" OR
city_name_ascii="Lyon" OR
city_name_ascii="Toulouse" OR
city_name_ascii="Nantes" OR
city_name_ascii="Montpellier" OR
city_name_ascii="Strasbourg" OR
city_name_ascii="Lille");
# Spain
INSERT INTO euromajorcities SELECT country_code, city_name_ascii, latitude, longitude, timezoneid FROM eurocity WHERE country_code="ES" AND (
city_name_ascii="Madrid" OR
city_name_ascii="Barcelona" OR
city_name_ascii="Valencia" OR
city_name_ascii="Sevilla" OR
city_name_ascii="Zaragoza" OR
city_name_ascii="Malaga" OR
city_name_ascii="Murcia" OR
city_name_ascii="Palma" OR
city_name_ascii="Las Palmas de Gran Canaria" OR
city_name_ascii="Bilbao");
# Albania
INSERT INTO euromajorcities SELECT country_code, city_name_ascii, latitude, longitude, timezoneid FROM eurocity WHERE country_code="AL" AND (
city_name_ascii="Tirana" OR
city_name_ascii="Durressi" OR
city_name_ascii="Vlore" OR
city_name_ascii="Elbasan" OR
city_name_ascii="Shkoder" OR
city_name_ascii="Fier" OR
city_name_ascii="Korce" OR
city_name_ascii="Berat");
#Andorra
INSERT INTO euromajorcities SELECT country_code, city_name_ascii, latitude, longitude, timezoneid FROM eurocity WHERE country_code="AD" AND (
city_name_ascii="Andorra la Vella" OR
city_name_ascii="Escaldes-Engordany" OR
city_name_ascii="Sant Julia de Loria" OR
city_name_ascii="Encamp" OR
city_name_ascii="La Massana" OR
city_name_ascii="Ordino" OR
city_name_ascii="Santa Coloma" OR
city_name_ascii="Canillo" OR
city_name_ascii="Pas de la Casa" OR
city_name_ascii="Arinsal");
#Austria
#SELECT * from eurocity WHERE country_code='AT' and city_name_ascii LIKE 'Sank%'
INSERT INTO euromajorcities SELECT country_code, city_name_ascii, latitude, longitude, timezoneid FROM eurocity WHERE country_code="AT" AND (
city_name_ascii="Wien" OR
city_name_ascii="Graz" OR
city_name_ascii="Linz" OR
city_name_ascii="Salzburg" OR
city_name_ascii="Innsbruck" OR
city_name_ascii="Klagenfurt" OR
city_name_ascii="Villach" OR
city_name_ascii="Wels" OR
city_name_ascii="Sankt Poelten");
#Belarus
#SELECT * from eurocity WHERE country_code='AT' and city_name_ascii LIKE 'Vic%'
INSERT INTO euromajorcities SELECT country_code, city_name_ascii, latitude, longitude, timezoneid FROM eurocity WHERE country_code="BY" AND (
city_name_ascii="Minsk" OR
city_name_ascii="Gomel" OR
city_name_ascii="Mogilev" OR
city_name_ascii="Vitebsk" OR
city_name_ascii="Hrodna" OR
city_name_ascii="Brest" OR
city_name_ascii="Babrujsk" OR
city_name_ascii="Baranovichi" OR
city_name_ascii="Barysaw" OR
city_name_ascii="Pinsk");
#Belgium
#SELECT * from eurocity WHERE country_code='BE' and city_name_ascii LIKE 'Brux%'
INSERT INTO euromajorcities SELECT country_code, city_name_ascii, latitude, longitude, timezoneid FROM eurocity WHERE country_code="BE" AND (
city_name_ascii="Antwerpen" OR
city_name_ascii="Gent" OR
city_name_ascii="Charleroi" OR
city_name_ascii="Liege" OR
city_name_ascii="Bruxelles-Capitale" OR
city_name_ascii="Schaerbeek" OR
city_name_ascii="Anderlecht" OR
city_name_ascii="Brugge" OR
city_name_ascii="Namur" OR
city_name_ascii="Leuven");
#Bosnia and herzegovina
#SELECT * from eurocity WHERE country_code='BA' and city_name_ascii LIKE 'Bihać%'
INSERT INTO euromajorcities SELECT country_code, city_name_ascii, latitude, longitude, timezoneid FROM eurocity WHERE country_code="BA" AND (
city_name_ascii="Sarajevo" OR
city_name_ascii="Banja Luka" OR
city_name_ascii="Tuzla" OR
city_name_ascii="Zenica" OR
city_name_ascii="Mostar" OR
city_name_ascii="Bijeljina" OR
city_name_ascii="Brcko" OR
city_name_ascii="Bihac");
#Bulgaria
#SELECT * from eurocity WHERE country_code='BG' and city_name_ascii LIKE 'Dobrič%'
INSERT INTO euromajorcities SELECT country_code, city_name_ascii, latitude, longitude, timezoneid FROM eurocity WHERE country_code="BG" AND (
city_name_ascii="Sofija" OR
city_name_ascii="Plovdiv" OR
city_name_ascii="Varna" OR
city_name_ascii="Burgas" OR
city_name_ascii="Ruse" OR
city_name_ascii="Stara Zagora" OR
city_name_ascii="Pleven" OR
city_name_ascii="Sliven" OR
city_name_ascii="Dobrich");
#Croatia
#SELECT * from eurocity WHERE country_code='HR' and city_name_ascii LIKE 'Slavonski Brod%'
INSERT INTO euromajorcities SELECT country_code, city_name_ascii, latitude, longitude, timezoneid FROM eurocity WHERE country_code="HR" AND (
city_name_ascii="Zagreb" OR
city_name_ascii="Split" OR
city_name_ascii="Rijeka" OR
city_name_ascii="Osijek" OR
city_name_ascii="Zadar" OR
city_name_ascii="Pula" OR
city_name_ascii="Sesvete" OR
city_name_ascii="Slavonski Brod");
#Cyprus
#SELECT * from eurocity WHERE country_code='CY' and city_name LIKE 'Lárnaka%'
INSERT INTO euromajorcities SELECT country_code, city_name_ascii, latitude, longitude, timezoneid FROM eurocity WHERE country_code="CY" AND (
city_name_ascii="Lemesos" OR
city_name_ascii="Strovolos" OR
city_name_ascii="Lefkosía" OR
city_name_ascii="Larnaka");
#Czechia (Czech Republic)
#SELECT * from eurocity WHERE country_code='CZ' and city_name LIKE 'Praha%'
INSERT INTO euromajorcities SELECT country_code, city_name_ascii, latitude, longitude, timezoneid FROM eurocity WHERE country_code="CZ" AND (
city_name_ascii="Prague" OR #as Praha in the database
city_name_ascii="Brno" OR
city_name_ascii="Ostrava" OR
city_name_ascii="Plzen" OR
city_name_ascii="Liberec" OR
city_name_ascii="Olomouc" OR
city_name_ascii="Ceske Budejovice" OR
city_name_ascii="Usti nad Labem" OR
city_name_ascii="Hradec Králové" OR
city_name_ascii="Pardubice");
#Denmark
#SELECT * from eurocity WHERE country_code='DK' and city_name LIKE 'Arh%'
INSERT INTO euromajorcities SELECT country_code, city_name_ascii, latitude, longitude, timezoneid FROM eurocity WHERE country_code="DK" AND (
city_name_ascii="Kobenhavn" OR
city_name_ascii="Arhus" OR
city_name_ascii="Odense" OR
city_name_ascii="Aalborg" OR
city_name_ascii="Esbjerg" OR
city_name_ascii="Randers" OR
city_name_ascii="Kolding" OR
city_name_ascii="Horsens" OR
city_name_ascii="Vejle" OR
city_name_ascii="Roskilde" OR
city_name_ascii="Herning");
#Estonia
#SELECT * from eurocity WHERE country_code='EE' and city_name LIKE 'Pärnu%'
INSERT INTO euromajorcities SELECT country_code, city_name_ascii, latitude, longitude, timezoneid FROM eurocity WHERE country_code="EE" AND (
city_name_ascii="Tallinn" OR
city_name_ascii="Tartu" OR
city_name_ascii="Narva" OR
city_name_ascii="Paernu" OR
city_name_ascii="Kohtla-Jaerve" OR
city_name_ascii="Viljandi" OR
city_name_ascii="Maardu" OR
city_name_ascii="Rakvere" OR
city_name_ascii="Kuressaare");
#FAROE ISLANDS
#SELECT * from eurocity WHERE country_code='FO' and city_name LIKE 'Saltangará%'
INSERT INTO euromajorcities SELECT country_code, city_name_ascii, latitude, longitude, timezoneid FROM eurocity WHERE country_code="FO" AND (
city_name_ascii="Torshavn" OR
city_name_ascii="Klaksvík" OR
city_name_ascii="Hoyvík" OR
city_name_ascii="Argir" OR
city_name_ascii="Fuglafjordur" OR
city_name_ascii="Vagur" OR
city_name_ascii="Vestmanna" OR
city_name_ascii="Midvagur" OR
city_name_ascii="Sorvagur" OR
city_name_ascii="Saltangara");