I need help entering this data. I want to transfer data from the customer 2 file into the table "Customer" but I always get errors, I am using MySQL workbench. Customer2, Employee2, and Supplier2 are all SQL file downloaded separately and this is what I am trying to enter. I have been stuck with this insert functions for days. PLEASE LOOK at my screenshot and the output results to see where I keep getting stuck, Thank you so much Query 1customer2employee2supplier2SQLAdditionsLimit to 1000 rows> | 1 1, | Jump to1.Automatic context help isdisabled. Use the toolbar t2Order of data:3lastName, firstName, address, city, state, zipCode, phone, emailmanually get help for thecurrent caret position or totoggle automatic help.4*/5Goodman, Yvonne, 12 Creekside St, Nashville, TN, 37205, 2025550109, ygoodman@isp.com78Mackenzie, Dante, 137 Wall St, Nashville, TN, 37205, 2025550112, dmackenzie@isp.com10Rollins, Alysha, 411 Shirley St, Nashville, TN, 37205, 2025550115, arollins@isp.com1112Gonzalez, Avaya, 7771 Border Court, Nashville, TN, 37205, 2025550119, agonzalez@isp.com13Kelly, Haniya, 6 South Sulphur Springs Street, Nashville, TN, 37205, 2025550121, hkelly@isp.com1415Chambers, Nathalie, 942 New Saddle Drive, Clover, sc, 29710, 2025550122, nchambers@isp.com161718Rollins, Dante, 9 Wrangler Ave, Clover, sc, 29710, 2025550124, drollins@isp.com19Mckee, Beverley, 7319 s. Greenview Drive, Clover, sc, 29712025550125, bmckee@isp.com2021Lindsey, Paris, 763 West Mulberry St, Clover, sc, 29710, 2025550132, plindsey@isp.com2223Melia, Umaiza, 545 Ohio Ave, Clover, Sc, 29710, 2025550135, umelia@isp.com242526Prince, Nico, 20 Middle River Street, Willoughby, OH, 44094, 2025550137, nprince@isp.com2728Rennie, Javan, 8112 North Country St, Willoughby, OH, 44094, 2025550139, jrennie@isp.com2930Waters, Ali, 83 Rockland Lane, Willoughby, OH, 44094, 2025550144, awaters@isp.comContext Help SnippetsOutputA Action OutputTimeActionMessageDuration / Fetch28 00:58:59 INSERT INTO CUSTOMER(lastName, first Name, address, city, state, zipCode, phone, email) SELECT lastName, first Name, address, city, state, zipCod.Error Code: 1146. Table frozenfood.customer2' doesnt exist0.000 sec29 00:59:07 SHOW DATABASES7 row(s) retumed0.000 sec / 0.000 sec30 00:59:07 USE FROZENFOODO row(s) affected0.000 sec31 00:59:07 SHOW TABLES3 row(s) retumed0.000 sec / 0.000 sec32 00:59:07 SELECT · FROM CUSTOMER LIMIT O, 10006 row(s) retumed0.000 sec / 0.000 sec33 00:59:07 INSERT INTO CUSTOMER(astName, first Name, address, city, state, zipCode, phone, email) SELECT last Name, first Name, address, city, state, zipCod.. Eror Code: 1062. Duplicate entry ygoodman@isp.com' for key 'customer.email"0.000 sec® 0 0 0 O O Query 1customer2employee2supplier2SQLAdditionsLimit to 1000 rowsI9 i, | Jump to1 .SHOW DATABASES;Automatic context help isdisabled. Use the toolbar tmanually get help for thecurrent caret position or ttoggle automatic help.2 .USE FROZENFOOD;3 •SHOW TABLES;4.SELECT * FROM CUSTOMER;INSERT INTO CUSTOMER (lastName, firstName, address, city, state, zipCode, phone, email)SELECT lastName, firstName, address, city, state, zipcode, phone, email FROM customen;5 •6Result Grid I O Filter Rows:Edit: A A R Export/Import: A 8 wrap Cell Content: IAIDlastNamefirstNameaddresscitystatezipCodephoneemail12 Creekside StNashvilleygoodman@isp.comResultGrid1GoodmanYvonneTN3720520255501092MackenzieDante137 Wall StNashvilleTN372052025550112dmackenzie@isp.comRollinsAlysha411 Shirley StNashvilleTN372052025550115arollins@isp.comAvaya7771 Border CourtNashville372052025550119agonzalez@isp.comhkelly@isp.comGonzalezTNFormKellyHaniya6 South Sulphur Springs StreetNashvilleTN372052025550121Editor7NULLChambersNULLNathalieNULL942 New Saddle DriveNULLCloverNULLnchambers@isp.comNULLSC297102025550122NULLNULLNULLFieldТурesQueryŠtatsExecutionPlanResult 19Result 20CUSTOMER 21 xApplyI Context Help SnippetsOutputA Action OutputMessageDuration / FetchTimeAction28 00:58:59 INSERT INTO CUSTOMER(lastName, first Name, address, city, state, zipCode, phone, email) SELECT last Name, first Name, address, city, state, zipCod.Eror Code: 1146. Table frozenfood.customer2' doesnt exist0.000 sec7 row(s) retumedO row(s) affected29 00:59:07 SHOW DATABASES0.000 sec / 0.000 sec30 00:59:07 USE FROZENFOOD0.000 sec31 00:59:07 SHOW TABLES3 row(s) retumed0.000 sec / 0.000 sec32 00:59:07 SELECT • FROM CUSTOMER LIMIT 0, 10006 row(s) retumed0.000 sec / 0.000 sec33 00:59:07 INSERT INTO CUSTOMER(ast Name, first Name, address, city, state, zipCode, phone, email) SELECT lastName, first Name, address, city, state, zipCod. Error Code: 1062. Duplicate entry ygoodman@isp.com' for key 'customer.email"0.000 secO 0 0 0 O O

Make sure the tables Customer and Customer2 are created in database FROZENFOOD. Data of one table…

Answered: I need help entering this data. I want…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...