Question

Hi I have the following Code and it Keeps giving me This Error in EDUPE: ERROR 1064 (42000) at line 1.

Here is the Code I need to create a database with:

DROP TABLE IF EXISTS Order;
DROP TABLE IF EXISTS Customer;
DROP TABLE IF EXISTS Employee;
DROP TABLE IF EXISTS Payment;
DROP TABLE IF EXISTS Product;
DROP TABLE IF EXISTS InventoryReport;
DROP TABLE IF EXISTS DistributionChannel;

-- Table structure for table `Order`

CREATE TABLE Order
(Order_Number INT(100) PRIMARY KEY,
Product_Id VARCHAR(25) NOT NULL,
Quanity INT(100) NOT NULL,
Ship_Date DATE);

-- Data for table `Order`

INSERT INTO `Order` VALUES
(OrderNumber, ProductId, Quantity, ShipDate)
(2067980, '5678', '1', '2019-05-02'),
(2070369, '6867', '2', '2019-09-06'),
(2039542, '4652', '10', '2019-11-30');

-- table structure for `Employee`

CREATE TABLE Employee
(EmployeeID INT(15) PRIMARY KEY,
EmployeeFirstName VARCHAR(25) NOT NULL,
EmployeeLastName VARCHAR(25) NOT NULL,
EmployeeAddress VARCHAR(45) NOT NULL,
EmployeeCity VARCHAR(25) NOT NULL,
EmployeeZipcode VARCHAR(25) NOT NULL,
EmployeeState VARCHAR(25) NOT NULL);

INSERT INTO Employee VALUES
(EmployeeID, FirstName, LastName, Address, City, State, Zipcode)

(2468, 'Jason', 'Harmon', '10 Western Court', 'Howell', 'NJ', '07731'),

(2469, 'Gary', 'Hodgens', '1 Lewis Street', 'Secaucus', 'NJ', '07094'),

(2461, 'Mayla', 'Slate', '18 Sand Road', 'Milltown', 'NJ', '08850');

-- Table structure for table `Customer`

CREATE TABLE Customer
(CustomerID INT(35) PRIMARY KEY,
CustomerFirstName VARCHAR(25),
CustomerLastName VARCHAR(25) NOT NULL,
CustomerAddress VARCHAR(45) NOT NULL,
CustomerState VARCHAR(25),
CustomerZip INT(20) NOT NULL);

-- Data for table `Customer`
INSERT INTO Customer VALUES
(CustomerID, FirstName, LastName, Address, City, State, Zipcode, CustomerAcountNumber)

(01234, ‘John’, ‘Smith’, ‘3 Evergreen Drive’, ‘Nutley’, ‘NJ’, ‘9950’),

(01235, ‘Dave’, ‘Tee’, ‘6 Devry Road’, ‘Naperville’, ‘IL’, ‘60563’, ‘9961’),

(01236, ‘Jane’, ‘White’, ‘9 Conover Avenue’, ‘Arlington’, ‘VA’, ‘22202’, ‘9982’);

-- Table structure for table ‘Product’

CREATE TABLE Product
(ProductNumber INT(10) PRIMARY KEY,
ProductName VARCHAR(50) NOT NULL,
ProductModel VARCHAR(25),
ProductPrice Decimal(10),
Manufatcurer VARCHAR(25));

-- Data for table `Product`

INSERT INTO Product VALUES
(ProductNumber, Name, Model, Price, Brand)

(5678, 'TV', '60inch', '350', 'LG'),

(4652, 'Laptop', '17inch', '400', 'Toshiba'),

(6867, 'Radio', 'CDPlayer', '150', 'Bose');

-- Table structure for table `InventoryReport`

CREATE TABLE InventoryReport
(ItemNumber VARCHAR (25) PRIMARY KEY,
ItemSold INT(25) NOT NULL,
ItemsOnHand INT(500) NOT NULL,
BackOrdered VARCHAR(500));

-- Data for table `InventoryReport`

INSERT INTO InventortyReport VALUES
(ItemNumber, ItemSold, ItemsOnHand, BackOrdered)

(5678, '1', '100', '200'),

(6867, '2', '50', '150'),

(4652, '10', '300', '400');

-- Table structure for table `DistributionCannel`

CREATE TABLE DistributionChannel
(TrackingNumber VARCHAR(35) PRIMARY KEY,
CarrierName VARCHAR(45) NOT NULL,
CarrierType VARCHAR(45));

-- Data for table `DistributionChannel`
INSERT INTO 'DistributionChannel' VALUES
(TrackingNumber, CarrierName, CarrierType)

(6694, 'Fedex', 'Truck'),

(6695, 'UPS', 'Van'),

(6696, 'USPS', 'Car');

-- Table structure for table `Payment`

CREATE TABLE Payment
(CustomerAcountNumber INT(50) NOT NULL,
PaymentType VARCHAR(25),
Total Decimal (20));

-- Data for table `Payment`
INSERT INTO 'Payment' VALUES
(CustomerAcountNumber, PaymentType, Total)

(9950, 'Visa', '100.00'),

(9961, 'Echeck', '25.00'),

(9982, 'Mastercard', '32.00');

Select * from Order;
Select * from Customer;
Select * from Employee;
Select * from Payment;
Select * from Product;
Select * from InventoryReport;
Select * from DistributionChannel;

Please take a look as I am stumped on this error.

This Is using MSQL

Answer 1

CREATE TABLE Orders(OrderNumber INT (100) Primary Key,ProductId VARCHAR (25) NOT NULL,Quanity INT(100) NOT NULL,ShipDate DATE );

INSERT INTO Orders VALUES(2067980, '5678', '1' , '05-02-2019');
INSERT INTO Orders VALUES(2070369,'6867','2','09-06-2019');
INSERT INTO Orders VALUES(2039542, '4652', '10', '11-30-2019');

CREATE TABLE Employee(EmployeeID INT(15) Primary KEY,EmployeeFirstName VARCHAR (25) NOT NULL,EMployeeLastName VARCHAR (25) NOT NULL,
EmployeeAddress VARCHAR (45) NOT NULL,EmployeeCity VARCHAR (25) NOT NULL,EmployeeState VARCHAR (25) NOT NULL,Zipcode VARCHAR (25) NOT NULL);

INSERT INTO `Employee` VALUES(2468, 'Jason', 'Harmon', '10 Western Court', 'Howell', 'NJ', '07731');

INSERT INTO `Employee` VALUES(2469, 'Gary', 'Hodgens', '1 Lewis Street', Secaucus', 'NJ', '07094');

INSERT INTO `Employee` VALUES(2461, 'Mayla', 'Slate', '18 Sand Road', 'Milltown', 'NJ', '08850');

CREATE TABLE Customer( CustomerID int (35) PRIMARY KEY,CustomerFirstName varchar (25),CustomerLastName varchar (25) NOT NULL,
CustomerAddress varchar (45) NOT NULL,CustomerState varchar (25),CustomerZip int (20) NOT NULL) ;

INSERT INTO Customer VALUES(01234, 'John', 'Smith', '3 Evergreen Drive', 'NJ', '9950');
INSERT INTO Customer VALUES(01235, 'Dave', 'Tee', '6 Devry Road', 'IL', '9961');
INSERT INTO Customer VALUES(01236, 'Jane', 'White', '9 Conover Avenue', 'VA', '9982');

CREATE TABLE Product(ProductNumber INT (10) PRIMARY KEY,ProductName VARCHAR(50) NOT NULL,ProductModel VARCHAR (25),ProductPrice Decimal (10),
Manufatcurer VARCHAR (25));

INSERT INTO Product VALUES(5678, 'TV', '60inch', '350', 'LG');
INSERT INTO Product VALUES(4652, 'Laptop', '17inch', '400', 'Toshiba');
INSERT INTO Product VALUES(6867, 'Radio', 'CDPlayer', '150', 'Bose');

CREATE TABLE InventoryReport(ItemNumber VARCHAR (25) PRIMARY KEY,ItemSold int(25) NOT NULL,ItemsOnHand int (500) NOT NULL,
BackOrdered varchar(500)) ;

INSERT INTO InventoryReport VALUES(5678, '1', '100', '200');
INSERT INTO InventoryReport VALUES(6867, '2', '50', '150');
INSERT INTO InventoryReport VALUES(4652, '10', '300', '400');

CREATE TABLE DistributionChannel( TrackingNumber VARCHAR (35) Primary Key,CarrierName VARCHAR (45) NOT NULL,CarrierType VARCHAR (45)) ;

INSERT INTO DistributionChannel VALUES(6694, 'Fedex', 'Truck');
INSERT INTO DistributionChannel VALUES(6695, 'UPS', 'Van');
INSERT INTO DistributionChannel VALUES(6696, 'USPS', 'Car');

CREATE TABLE Payment( CustomerAcountNumber INT(50) NOT NULL,PaymentType VARCHAR (25),Total Decimal (20));

INSERT INTO Payment VALUES(9950, 'Visa','100.00');
INSERT INTO Payment VALUES(9961, 'Echeck','25.00');
INSERT INTO Payment VALUES(9982, 'Mastercard', '32.00');

Select * from Orders;

Select * from Customer;

Select * from Employee;

Select * from Payment;

Select * from Product;

Select * from InventoryReport;

Select * from DistributionChannel;