inserts.sql

drop table if exists mysql_schema.data_classes;
create table mysql_schema.data_classes (
id int not null AUTO_INCREMENT
,first_name varchar(100)
,surname varchar(100)
,gender varchar(100)
,email varchar(100)
,latitude varchar(100)
,longitude varchar(100)
,ip_address varchar(100)
,city varchar(100)
,country varchar(100)
,language varchar(100)

, PRIMARY KEY (id)
);insert into mysql_schema.data_classes (first_name,surname,gender,email,latitude,longitude,ip_address,city,country,language) 
 values 
('Suzi','Wentzell','Female','Suzi.Wentzell@gmail.com','-21.67851476','137.8567438','468.704.782.288','Cali','Colombia','Vietnamese')
,('Bok','Mcglade''s and Mcglade''s ''B''','Female','Bok.Mcglade@gmail.com','-22.25135677','138.5498918','862.651.219.841','Hiroshima','Japan','Tok Pisin')
,('Teodora','Worden','Female','Teodora.Worden@outlook.com','-22.76737732','140.7202675','448.111.274.821','Paris','France','French')
,('Thelma','Hornberger','Female','Thelma.Hornberger@outlook.com','-23.85862851','140.2765583','261.87.118.517','Davao City','Philippines','Filipino')
,('Kristan','Bontrager','Female','Kristan.Bontrager@gmail.com','-24.52434517','139.5108449','168.693.358.307','Hanoi','Vietnam','Mongolian')
,('Sharita','Rippeon','Female','Sharita.Rippeon@outlook.com','-22.38281214','139.0824962','561.778.524.716','Tripoli','Libya','Polish')
,('Leonora','Dipiazza','Female','Leonora.Dipiazza@gmail.com','-20.43028521','137.1291436','468.144.393.584','Lahore','Pakistan','Serbian')
,('Evelynn','Raatz','Female','Evelynn.Raatz@outlook.com','-23.69172497','137.334783','','Shiraz','Iran','Banjar')
,('Allyn','Manwaring','Female','Allyn.Manwaring@gmail.com','-24.3468839','140.585884','542.852.694.53','Sydney','Australia','English')
,('Jina','Nowell','Female','Jina.Nowell@gmail.com','-20.37575144','138.3286443','245.297.301.701','Beijing','China','Mandarin')
,('Tatum','Toscano','Female','Tatum.Toscano@outlook.com','-23.39496747','136.5504131','653.975.89.359','Patna','India','Hindi')
,('Shalanda','Novoa','Female','Shalanda.Novoa@gmail.com','-20.89398246','140.2056253','424.57.862.17','Lahore','Pakistan','Moroccan Arabic')
,('Arnette','Bainter','Female','Arnette.Bainter@outlook.com','-400.0','400.0','191.551.873.717','Bogot','Colombia','Libyan Arabic')
,('Keren','Nowlen','Female','Keren.Nowlen@gmail.com','-20.89884507','140.1785837','671.62.357.814','Budapest','Hungary','Northern Hindko')
,('Delia','Nesby','F','Delia.Nesby@outlook.com','-24.08071308','140.1424174','344.140.502.385','Sydney','Australia','Slovenian')
,('Trina','Keel','Female','Trina.Keel@gmail.com','-22.33238663','138.4181668','25.402.166.452','Surabaya','Indonesia','Indonesian')
,('Matilda','Scully','Female','Matilda.Scully@gmail.com','-24.43244278','140.357526','714.805.701.637','Cali','Colombia','Swahili')
,('Davida','Exley','Female','Davida.Exley@outlook.com','-21.70617071','137.0514031','474.926.609.317','Jinan','China','Kyrgyz')
,('Jenelle','Sergeant','Female','Jenelle.Sergeant@outlook.com','-22.68461631','139.3523617','612.185.560.334','Dhaka','Bangladesh','Vietnamese')
,('Nohemi','Mcvey','Female','Nohemi.Mcvey@gmail.com','0','0','818.792.92.643','Kawasaki','Japan','Finnish')
,('Argelia','Mcloughlin','Female','Argelia.Mcloughlin@outlook.com','-21.36259492','137.4132587','179.613.922.676','Houston','UnitedStates','English')
,('Paulina','Behnke','Female','Paulina.Behnke@gmail.com','-23.87889673','137.9452319','800.195.946.512','Luanda','Angola','Amharic')
,('Lyndsey','Jensen','Female','Lyndsey.Jensen@gmail.com','-22.09026005','139.7891258','845.777.85.445','Changchun','China','Mandarin')
,('Joannie','Berthelot','Female','Joannie.Berthelot@outlook.com','-22.44764946','137.8402332','470.601.636.525','Almaty','Kazakhstan','Ta izzi-Adeni Arabic')
,('Lizzie','Varian','Female','Lizzie.Varian@gmail.com','-22.46655219','137.1637868','737.519.855.23','Montevideo','Uruguay','Tunisian Arabic')
,('Christa','Muck','Female','Christa.Muck@gmail.com','-24.47318059','140.3689318','935.374.700.794','Nizhny Novgorod','Russia','Pattani Malay')
,('Cammy','Stivers','Female','Cammy.Stivers@gmail.com','-20.4261607','140.1474271','18.544.290.628','Madrid','Spain','Icelandic')
,('Natacha','Brake','Female','Natacha.Brake@outlook.com','-20.49279517','138.760118','579.42.216.965','Foshan','China','Mandarin')
,('Francie','Lozano','Female','Francie.Lozano@outlook.com','-19.98853208','137.771768','109.986.381.88','Mumbai','India','Gibberish')
,('Dolores','Rousselle','Female','Dolores.Rousselle@gmail.com','-19.93285684','137.4418446','891.739.463.509','Lanzhou','China','Jinyu')
,('Ngan','Szczepanski','Female','Ngan.Szczepanski@outlook.com','-23.35693752','137.7676492','475.48.911.783','Santa Cruzdela Sierra','Bolivia','Turkmen')
,('Yuk','Dubrey','Female','Yuk.Dubrey@outlook.com','-20.51566422','138.1397683','945.494.939.397','Patna','India','Vietnamese')
,('Anjanette','Gameros','Female','Anjanette.Gameros@outlook.com','-24.32863374','140.6264231','281.655.234.216','Cologne','Germany','Pig Latin')
,('Rolanda','Lisowski','Female','Rolanda.Lisowski@outlook.com','-21.01914402','140.0340618','368.440.27.86','Salvador','Brazil','Yue')
,('Annabel','Strohmeyer','Female','Annabel.Strohmeyer@gmail.com','-22.36824921','138.4273233','442.11.138.339','Montevideo','Uruguay','Marshallese')
,('Nickole','Capito','Female','Nickole.Capito@gmail.com','-23.77096364','137.7066024','126.325.450.794','Shantou','China','Catal n')
,('Agustina','Iliff','Female','Agustina.Iliff@gmail.com','-23.13720994','140.9011374','728.165.982.470','Milan','Italy','Russian')
,('Agatha','Pollitt','Female','Agatha.Pollitt@gmail.com','-20.53679998','139.7048221','888.108.940.965','Nizhny Novgorod','Russia','French')
,('Angle','Raimondi','Female','Angle.Raimondi@gmail.com','-21.10507226','139.6247482','135.101.945.205','Santa Cruzdela Sierra','Bolivia','Jambi Malay')
,('Sherrie','Reuter','Female','Sherrie.Reuter@outlook.com','-23.49661248','140.1937546','43.156.660.579','Karachi','Pakistan','Jinyu')
,('Katherina','Rhinehart','Female','Katherina.Rhinehart@outlook.com','-23.83725414','140.3763502','211.553.521.120','Hamburg','Germany','German')
,('Kimberely','Haymon','Female','Kimberely.Haymon@gmail.com','-23.58370736','138.5665108','545.136.290.380','Lahore','Pakistan','Sinhala')
,('Alda','Gillham','Female','Alda.Gillham@outlook.com','-20.1564545','139.6699051','825.648.669.391','Managua','Nicaragua','Klingon')
,('Lorraine','Baumer','Female','Lorraine.Baumer@outlook.com','-21.20376','136.8714274','16.635.59.716','San Antonio','United States','English')
,('Lashunda','Moffatt','Female','Lashunda.Moffatt@gmail.com','-19.74813959','140.4580057','424.193.235.92','Los Angeles','United States','English')
,('Carina','Ollison','Female','Carina.Ollison@gmail.com','-23.79570906','136.7812167','206.323.350.401','Shanghai','China','French')
,('Tamatha','Plotkin','Female','Tamatha.Plotkin@gmail.com','-22.05691437','140.8901638','301.8.347.995','Shenzhen','China','Mandarin')
,('Anamaria','Quill','Female','Anamaria.Quill@gmail.com','-23.86809803','140.0370019','226.599.892.866','Davao City','Philippines','Filipino')
,('Polly','Mincey','Female','Polly.Mincey@outlook.com','-20.68184445','137.1051584','802.516.480.787','Melbourne','Australia','English')
,('Jettie','Qualey','Female','Jettie.Qualey@outlook.com','-21.39258742','140.2923091','715.971.598.646','Riode Janeiro','Brazil','Portuguese')
,('Rogelio','Kohl','Male','Rogelio.Kohl@outlook.com','-19.94573227','140.6710097','111.900.187.680','Dares Salaam','Tanzania','Nauruan')
,('Willian','Lorenz','Male','Willian.Lorenz@outlook.com','-24.63494382','140.8445491','228.581.275.918','Abidjan','IvoryCoast','Bosnian')
,('Robert','Guimond','Male','Robert.Guimond@outlook.com','-22.59295399','136.9450481','980.113.767.990','Madrid','Spain','Bangla')
,('Karl','Mcmanus','Male','Karl.Mcmanus@gmail.com','-22.41744504','140.0383733','132.913.407.999','Ulsan','South','Swahili')
,('Jake','Lett','Male','Jake.Lett@gmail.com','-23.92703466','137.5937223','607.612.820.410','Singapore','Singapore','North Levantine Arabic')
,('Edward','Santoyo','Male','Edward.Santoyo@outlook.com','-22.03287837','137.0955763','524.379.595.915','Sofia','Bulgaria','Pu-Xian')
,('Margarito','Aronowitz','Male','Margarito.Aronowitz@outlook.com','-23.31430722','137.3755008','26.148.9.295','Surat','India','Min Bei')
,('Jonathan','Hudnall','Male','Jonathan.Hudnall@gmail.com','-24.4952937','139.460106','993.251.649.112','Sydney','Australia','Pig Latin')
,('Jacques','Miler','Male','Jacques.Miler.outlook.com','-23.40222491','139.5357051','835.321.895.281','Tashkent','Uzbekistan','Italian')
,('Hugo','Laboy','Male','Hugo.Laboy@gmail.com','-21.58126411','139.2882914','295.602.636.718','Mumbai','India','Musi')
,('Gavin','Massengale','Male','Gavin.Massengale@outlook.com','-24.13294302','138.889434','43.471.482.129','Accra','Ghana','Tuvaluan')
,('Geoffrey','Audette','Male','Geoffrey.Audette@outlook.com','-22.23546219','137.3385979','421.618.364.781','Zhengzhou','China','Albanian')
,('Numbers','Shelor','Male','Numbers.Shelor@gmail.com','-20.63302521','137.6970719','173.941.885.590','Baku','Azerbaijan','Croatian')
,('Garfield','Woodson','Male','Garfield.Woodson@gmail.com','-24.64885297','139.8962746','881.531.520.979','Tbilisi','Georgia','Uzbek')
,('Osvaldo','Wissing','Male','Osvaldo.Wissing@gmail.com','-22.29554299','139.8612177','913.113.276.720','Nagpur','India','Eastern Egyptian Bedawi Arabic')
,('Bobby','Steveson','Male','Bobby.Steveson@gmail.com','-21.53829377','140.7733533','92.497.666.477','Salvador','Brazil','Dothraki')
,('Michale','Troy','Male','Michale.Troy@outlook.com','-20.54315642','140.6248785','606.605.258.488','Minsk','Belarus','IsiZulu')
,('Dane','Mesta','Unknown','Dane.Mesta@outlook.com','-20.63007705','138.2202974','707.387.239.30','Bengaluru','India','Hakka')
,('Greg','Deming','Male','Greg.Deming@outlook.com','-20.55489272','140.7944736','763.337.296.841','Wenzhou','China','Korean')
,('Marion','Kleckner','Male','Marion.Kleckner@gmail.com','-21.61251123','140.7501758','476.765.985.920','SaintPetersburg','Russia','Russian')
,('Arden','Karls','Male','Arden.Karls@outlook.com','-19.87867191','139.8320322','127.868.791.957','Changsha','China','Sanaani Arabic')
,('Buddy','Warnick','Male','Buddy.Warnick@outlook.com','-22.53330186','138.7353923','868.910.386.724','New Taipei City','Taiwan','Cantonese')
,('Denver','Morejon','Male','Denver.Morejon@outlook.com','-23.66609788','139.1547393','547.491.567.860','Ulsan','South','Tajik')
,('Rodney','Habel','Male','Rodney.Habel@gmail.com','-21.88787198','137.8648029','944.462.210.746','Kathmandu','Nepal','Khmer')
,('Carmelo','Kyle','Male','Carmelo.Kyle@outlook.com','-21.42338225','141.1050111','216.290.460.637','Ho Chi Minh City','Vietnam','Vietnamese')
,('Vance','Mcjunkin','Male','Vance.Mcjunkin@outlook.com','-24.04994986','139.7571652','912.260.164.750','Toronto','Canada','English')
,('Truman','Cho','Male','Truman.Cho@outlook.com','-22.93794157','140.1559786','828.245.646.753','Tabriz','Iran','Bislama')
,('Omar','Pless','Male','Omar.Pless@outlook.com','-21.23798631','137.9121843','156.620.284.576','Bogot','Colombia','Thai')
,('Quintin','Doria','Male','Quintin.Doria@gmail.com','-20.69776195','140.1372528','0.790.850.867','Dallas','United States','Jambi Malay')
,('Courtney','Widell','Male','Courtney.Widell@gmail.com','-21.55944585','136.945766','732.638.361.662','Campinas','Brazil','Bangla')
,('Lenny','Ferebee','Male','Lenny.Ferebee@outlook.com','-23.2881145','137.7594945','755.989.911.314','Tripoli','Libya','Mongolian')
,('Tad','Salter','Male','Tad.Salter@gmail.com','-23.6288189','141.1158481','99.730.797.25','Prague','Czech Republic','Azerbaijani Turkic')
,('Paul','Schacht','Male','Paul.Schacht@gmail.com','-21.22676202','140.2849256','237.574.951.186','Durban','South Africa','Finnish')
,('Adan','Dufrene','Male','Adan.Dufrene@outlook.com','-22.12724868','138.0973039','523.571.607.241','Baku','Azerbaijan','Musi')
,('Heath','Conforti','M','Heath.Conforti@gmail.com','-20.36589625','138.1536104','566.36.285.740','Tainan','Taiwan','Central Malay')
,('Brock','Norfleet','Male','Brock.Norfleet@outlook.com','-21.69808393','139.1397148','447.855.762.580','Rawalpindi','Pakistan','Macedonian')
,('Danilo','Lawalin','Male','Danilo.Lawalin@outlook.com','-23.09485479','137.3160072','962.521.1.508','Delhi','India','Kedah Malay')
,('Bart','Medina','Male','Bart.Medina@outlook.com','-20.79627454','136.8806545','345.864.241.829','Montreal','Canada','English')
,('Lamont','Predmore','Male','Lamont.Predmore@outlook.com','-22.68629364','140.4972109','109.227.6.921','Belo Horizonte','Brazil','Portuguese')
,('Arnold','Viator','Man','Arnold.Viator@outlook.com','-23.69458761','137.4351614','958.810.866.4','Baku','Azerbaijan','Khmer')
,('Moises','Sowell','Male','Moises.Sowell@outlook.com','-24.474529','138.2875307','564.542.555.50','Sapporo','Japan','Japanese')
,('Harry','Boling','Male','Harry.Boling@gmail.com','-23.29619591','136.5569916','974.455','Ulsan','South','Sudanese Arabic')
,('Brent','Gayhart','Male','Brent.Gayhart@outlook.com','-21.38891481','140.1764538','679.621.175.160','Bangkok','Thailand','Pahari-Potwari')
,('Rubin','Armitage','Male','Rubin.Armitage@gmail.com','-23.65653774','139.437962','42.520.851.787','Tainan','Taiwan','Cantonese')
,('Tony','Hoggard','Male','Tony.Hoggard@gmail.com','-20.54015413','137.5400385','920.406.12.389','Beijing','China','Afar')
,('Lesley','Pankow','Male','Lesley.Pankow@','-21.70856798','139.9684061','643.575.883.23','Jeddah','SaudiArabia','Seselwa Creole')
,('Ismael','Mary','M','Ismael.Mary@outlook.com','-23.12508348','141.185741','815.710.901.781','Lagos','Nigeria','Hebrew')
,('Royce','Westmoreland','Male','Royce.Westmoreland@gmail.com','-22.79712809','141.0441569','989.167.35.607','Sofia','Bulgaria','Dutch')
,('Jaime','Sanor','Male','Jaime.Sanor@outlook.com','-21.70383774','137.2021821','500.105.570.54','Karaj','Iran','Kyrgyz')
,('Hugh','Spiva','Male','Hugh.Spiva@outlook.com','-19.7787555','137.7994836','311.859.396.564','Chaozhou','China','Mandarin');