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
Luke
Skywalker
Maiden Lane
New York
NY
Winston
Smith
Sycamore Street
Greensboro
NC
MaryAnne
Jenkins
Coconut Way
Jupiter
FL
Janet
Williams
Redondo Beach Blvd
Torrence
CA
Insert screenshot and brief explanation here.
Orders Table
OrderID
CustomerID
SKU
Description
ADVC
Advanced Switch GigE Copper port
ADVF
Advanced Switch GigE CopperFiber port copper port fiber
ENTF
Enterprise Switch GigE SFP Port
ENTF
Enterprise Switch GigE SFP port
Insert screenshot and brief explanation here.
mysql INSERT INTO Customers CustomerID FirstName, LastName, StreetAddress, City, State, ZipCode, Telephone
VALUES
'Luke', 'Skywalker', Maiden Lane', 'New York', NY
'Winston', 'Smith', Sycamore Street', 'Greensboro', NC
'MaryAnne', 'Jenkins', Coconut Way', 'Jupiter', FL
'Janet', 'Williams', Redondo Beach Blvd 'Torrence', CA;
ERROR S: Unknown column 'StreetAddress' in 'field list'
mysql
mysql INSERT INTO Orders OrderID CustomerID, SKU, Description
VALUES
'ADV 'Advanced Switch GigE Copper port'
'ADVF 'Advanced Switch GigE CopperFiber port copper port fiber'
'ENTF 'Enterprise Switch GigE SFP Port'
'ENTF 'Enterprise Switch GigE SFP port';
ERROR : Data too long for column 'Description' at row
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
