Question: I am having issues with this sql statement and getting errors. What does the error mean? and how I go about fixing this? a .

I am having issues with this sql statement and getting errors. What does the error mean? and how I go about fixing this?
a. Write a SQL query to insert four new records into the Orders and Customers tables using the data below:
Customers Table
CustomerID
FirstName
LastName
StreetAddress
City
State
ZipCode
Telephone
100004
Luke
Skywalker
15 Maiden Lane
New York
NY
10222
212-555-1234
100005
Winston
Smith
123 Sycamore Street
Greensboro
NC
27401
919-555-6623
100006
MaryAnne
Jenkins
1 Coconut Way
Jupiter
FL
33458
321-555-8907
100007
Janet
Williams
55 Redondo Beach Blvd
Torrence
CA
90501
310-555-5678
[Insert screenshot and brief explanation here.]
Orders Table
OrderID
CustomerID
SKU
Description
1204305
100004
ADV-24-10C
Advanced Switch 10GigE Copper 24 port
1204306
100005
ADV-48-10F
Advanced Switch 10 GigE Copper/Fiber 44 port copper 4 port fiber
1204307
100006
ENT-24-10F
Enterprise Switch 10GigE SFP+24 Port
1204308
100007
ENT-48-10F
Enterprise Switch 10GigE SFP+48 port
[Insert screenshot and brief explanation here.]
mysql> INSERT INTO Customers (CustomerID, FirstName, LastName, StreetAddress, City, State, ZipCode, Telephone)
-> VALUES
->(100004, 'Luke', 'Skywalker', '15 Maiden Lane', 'New York', 'NY','10222','212-555-1234'),
->(100005, 'Winston', 'Smith', '123 Sycamore Street', 'Greensboro', 'NC','27401','919-555-6623'),
->(100006, 'MaryAnne', 'Jenkins', '1 Coconut Way', 'Jupiter', 'FL','33458','321-555-8907'),
->(100007, 'Janet', 'Williams', '55 Redondo Beach Blvd', 'Torrence', 'CA','90501','310-555-5678');
ERROR 1054(42S22): Unknown column 'StreetAddress' in 'field list'
mysql>
mysql> INSERT INTO Orders (OrderID, CustomerID, SKU, Description)
-> VALUES
->(1204305,100004, 'ADV-24-100', 'Advanced Switch 10GigE Copper 24 port'),
->(1204306,100005, 'ADV-48-10F', 'Advanced Switch 10GigE Copper/Fiber 44 port copper 4 port fiber'),
->(1204307,100006, 'ENT-24-10F', 'Enterprise Switch 10GigE SFP+24 Port'),
->(1204308,100007, 'ENT-48-10F', 'Enterprise Switch 10GigE SFP+48 port');
ERROR 1406(22001): Data too long for column 'Description' at row 2
I am having issues with this sql statement and

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!