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
Transcribed Image Text:Query 1 customer2 employee2 supplier2 SQLAdditions Limit to 1000 rows > | 1 1, | Jump to 1. Automatic context help is disabled. Use the toolbar t 2 Order of data: 3 lastName, firstName, address, city, state, zipCode, phone, email manually get help for the current caret position or to toggle automatic help. 4 */ 5 Goodman, Yvonne, 12 Creekside St, Nashville, TN, 37205, 2025550109, ygoodman@isp.com 7 8 Mackenzie, Dante, 137 Wall St, Nashville, TN, 37205, 2025550112, dmackenzie@isp.com 10 Rollins, Alysha, 411 Shirley St, Nashville, TN, 37205, 2025550115, arollins@isp.com 11 12 Gonzalez, Avaya, 7771 Border Court, Nashville, TN, 37205, 2025550119, agonzalez@isp.com 13 Kelly, Haniya, 6 South Sulphur Springs Street, Nashville, TN, 37205, 2025550121, hkelly@isp.com 14 15 Chambers, Nathalie, 942 New Saddle Drive, Clover, sc, 29710, 2025550122, nchambers@isp.com 16 17 18 Rollins, Dante, 9 Wrangler Ave, Clover, sc, 29710, 2025550124, drollins@isp.com 19 Mckee, Beverley, 7319 s. Greenview Drive, Clover, sc, 2971 2025550125, bmckee@isp.com 20 21 Lindsey, Paris, 763 West Mulberry St, Clover, sc, 29710, 2025550132, plindsey@isp.com 22 23 Melia, Umaiza, 545 Ohio Ave, Clover, Sc, 29710, 2025550135, umelia@isp.com 24 25 26 Prince, Nico, 20 Middle River Street, Willoughby, OH, 44094, 2025550137, nprince@isp.com 27 28 Rennie, Javan, 8112 North Country St, Willoughby, OH, 44094, 2025550139, jrennie@isp.com 29 30 Waters, Ali, 83 Rockland Lane, Willoughby, OH, 44094, 2025550144, awaters@isp.com Context Help Snippets Output A Action Output Time Action Message Duration / Fetch 28 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 exist 0.000 sec 29 00:59:07 SHOW DATABASES 7 row(s) retumed 0.000 sec / 0.000 sec 30 00:59:07 USE FROZENFOOD O row(s) affected 0.000 sec 31 00:59:07 SHOW TABLES 3 row(s) retumed 0.000 sec / 0.000 sec 32 00:59:07 SELECT · FROM CUSTOMER LIMIT O, 1000 6 row(s) retumed 0.000 sec / 0.000 sec 33 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
Transcribed Image Text:Query 1 customer2 employee2 supplier2 SQLAdditions Limit to 1000 rows I9 i, | Jump to 1 . SHOW DATABASES; Automatic context help is disabled. Use the toolbar t manually get help for the current caret position or t toggle 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 • 6 Result Grid I O Filter Rows: Edit: A A R Export/Import: A 8 wrap Cell Content: IA ID lastName firstName address city state zipCode phone email 12 Creekside St Nashville ygoodman@isp.com Result Grid 1 Goodman Yvonne TN 37205 2025550109 2 Mackenzie Dante 137 Wall St Nashville TN 37205 2025550112 dmackenzie@isp.com Rollins Alysha 411 Shirley St Nashville TN 37205 2025550115 arollins@isp.com Avaya 7771 Border Court Nashville 37205 2025550119 agonzalez@isp.com hkelly@isp.com Gonzalez TN Form Kelly Haniya 6 South Sulphur Springs Street Nashville TN 37205 2025550121 Editor 7 NULL Chambers NULL Nathalie NULL 942 New Saddle Drive NULL Clover NULL nchambers@isp.com NULL SC 29710 2025550122 NULL NULL NULL Field Турes Query Štats Execution Plan Result 19 Result 20 CUSTOMER 21 x Apply I Context Help Snippets Output A Action Output Message Duration / Fetch Time Action 28 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 exist 0.000 sec 7 row(s) retumed O row(s) affected 29 00:59:07 SHOW DATABASES 0.000 sec / 0.000 sec 30 00:59:07 USE FROZENFOOD 0.000 sec 31 00:59:07 SHOW TABLES 3 row(s) retumed 0.000 sec / 0.000 sec 32 00:59:07 SELECT • FROM CUSTOMER LIMIT 0, 1000 6 row(s) retumed 0.000 sec / 0.000 sec 33 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 sec O 0 0 0 O O

Question

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 1
customer2
employee2
supplier2
SQLAdditions
Limit to 1000 rows
> | 1 1, | Jump to
1.
Automatic context help is
disabled. Use the toolbar t
2
Order of data:
3
lastName, firstName, address, city, state, zipCode, phone, email
manually get help for the
current caret position or to
toggle automatic help.
4
*/
5
Goodman, Yvonne, 12 Creekside St, Nashville, TN, 37205, 2025550109, ygoodman@isp.com
7
8
Mackenzie, Dante, 137 Wall St, Nashville, TN, 37205, 2025550112, dmackenzie@isp.com
10
Rollins, Alysha, 411 Shirley St, Nashville, TN, 37205, 2025550115, arollins@isp.com
11
12
Gonzalez, Avaya, 7771 Border Court, Nashville, TN, 37205, 2025550119, agonzalez@isp.com
13
Kelly, Haniya, 6 South Sulphur Springs Street, Nashville, TN, 37205, 2025550121, hkelly@isp.com
14
15
Chambers, Nathalie, 942 New Saddle Drive, Clover, sc, 29710, 2025550122, nchambers@isp.com
16
17
18
Rollins, Dante, 9 Wrangler Ave, Clover, sc, 29710, 2025550124, drollins@isp.com
19
Mckee, Beverley, 7319 s. Greenview Drive, Clover, sc, 2971
2025550125, bmckee@isp.com
20
21
Lindsey, Paris, 763 West Mulberry St, Clover, sc, 29710, 2025550132, plindsey@isp.com
22
23
Melia, Umaiza, 545 Ohio Ave, Clover, Sc, 29710, 2025550135, umelia@isp.com
24
25
26
Prince, Nico, 20 Middle River Street, Willoughby, OH, 44094, 2025550137, nprince@isp.com
27
28
Rennie, Javan, 8112 North Country St, Willoughby, OH, 44094, 2025550139, jrennie@isp.com
29
30
Waters, Ali, 83 Rockland Lane, Willoughby, OH, 44094, 2025550144, awaters@isp.com
Context Help Snippets
Output
A Action Output
Time
Action
Message
Duration / Fetch
28 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 exist
0.000 sec
29 00:59:07 SHOW DATABASES
7 row(s) retumed
0.000 sec / 0.000 sec
30 00:59:07 USE FROZENFOOD
O row(s) affected
0.000 sec
31 00:59:07 SHOW TABLES
3 row(s) retumed
0.000 sec / 0.000 sec
32 00:59:07 SELECT · FROM CUSTOMER LIMIT O, 1000
6 row(s) retumed
0.000 sec / 0.000 sec
33 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 1
customer2
employee2
supplier2
SQLAdditions
Limit to 1000 rows
I9 i, | Jump to
1 .
SHOW DATABASES;
Automatic context help is
disabled. Use the toolbar t
manually get help for the
current caret position or t
toggle 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 •
6
Result Grid I O Filter Rows:
Edit: A A R Export/Import: A 8 wrap Cell Content: IA
ID
lastName
firstName
address
city
state
zipCode
phone
email
12 Creekside St
Nashville
ygoodman@isp.com
Result
Grid
1
Goodman
Yvonne
TN
37205
2025550109
2
Mackenzie
Dante
137 Wall St
Nashville
TN
37205
2025550112
dmackenzie@isp.com
Rollins
Alysha
411 Shirley St
Nashville
TN
37205
2025550115
arollins@isp.com
Avaya
7771 Border Court
Nashville
37205
2025550119
agonzalez@isp.com
hkelly@isp.com
Gonzalez
TN
Form
Kelly
Haniya
6 South Sulphur Springs Street
Nashville
TN
37205
2025550121
Editor
7
NULL
Chambers
NULL
Nathalie
NULL
942 New Saddle Drive
NULL
Clover
NULL
nchambers@isp.com
NULL
SC
29710
2025550122
NULL
NULL
NULL
Field
Турes
Query
Štats
Execution
Plan
Result 19
Result 20
CUSTOMER 21 x
Apply
I Context Help Snippets
Output
A Action Output
Message
Duration / Fetch
Time
Action
28 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 exist
0.000 sec
7 row(s) retumed
O row(s) affected
29 00:59:07 SHOW DATABASES
0.000 sec / 0.000 sec
30 00:59:07 USE FROZENFOOD
0.000 sec
31 00:59:07 SHOW TABLES
3 row(s) retumed
0.000 sec / 0.000 sec
32 00:59:07 SELECT • FROM CUSTOMER LIMIT 0, 1000
6 row(s) retumed
0.000 sec / 0.000 sec
33 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 sec
O 0 0 0 O O

Accepted Answer

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