It wont let me insert my Orders values or Part order values
It won\'t let me insert my Orders values or Part order values. For Orders it keeps saying Customer.cID does not exist but as you can see I have the foreign key set for the orders table.
CREATE TABLE `jasocook_366f16`.`Employee` (
`eID` INT NOT NULL,
`fName` VARCHAR(45) NULL,
`lName` VARCHAR(45) NULL,
`zip` INT NULL,
PRIMARY KEY (`eID`));
CREATE TABLE `jasocook_366f16`.`Telephone` (
`tID` INT NOT NULL,
`eID` INT NULL,
`tNumber` INT NULL,
PRIMARY KEY (`tID`),
foreign key (eID) references Employee(eID));
CREATE TABLE `jasocook_366f16`.`Customer` (
`cID` INT NOT NULL,
`fName` VARCHAR(45) NULL,
`lName` VARCHAR(45) NULL,
`street` VARCHAR(50) NULL,
`city` VARCHAR(100) NULL,
`zip` INT NULL,
PRIMARY KEY (`cID`));
CREATE TABLE `jasocook_366f16`.`Part` (
`pID` INT NOT NULL,
`pName` VARCHAR(1000) NULL,
`price` INT NULL,
`quantity` INT NULL,
PRIMARY KEY (`pID`));
CREATE TABLE `jasocook_366f16`.`Orders` (
`oID` INT NOT NULL,
`rDate` DATE NULL,
`sDate` DATE NULL,
`cID` INT NULL,
`eID` INT NULL,
PRIMARY KEY (`oID`),
foreign key (cID) references Customer(cID),
foreign key (eID) references Employee(eID));
CREATE TABLE `jasocook_366f16`.`PartOrder` (
`pOID` INT NOT NULL,
`pID` INT NULL,
`oID` INT NULL,
`quantity` INT NULL,
PRIMARY KEY (`pOID`),
foreign key (pID) references Part(pID),
foreign key (oID) references Orders(oID));
insert into Employee values(1,\'Jason\',\'Cook\', 58104);
insert into Employee values(2,\'Alison\',\'Olson\',58104);
insert into Telephone values(1,1,1234567891);
insert into Telephone values(2,2,234567891);
insert into Customer values(1,\'Pam\',\'Wiseman\', \'123 West Palm St.\',\'Chicago\',23456);
insert into Customer values(2,\'John\',\'Wayne\', \'123 Bang Bang St.\',\'Austin\',55555);
insert into Part values(1,\'Part1\', 120, 2);
insert into Part values(2,\'Part2\', 500, 2);
insert into Orders values(1,\'09/28/2016\',\'09/13/2016\',Customer.cID(1),eID(1));
insert into Orders values(2,\'10/09/2016\',\'09/30/2016\',cID(2),eID(2));
insert into PartOrder values(1,Part.pID(1), Orders.oID(1),1);
insert into PartOrder values(2,Part.pID(2),Orders.oID(2),1);
HELP!
Solution
Please use below commands.
insert into Orders values(1,\'09/28/2016\',\'09/13/2016\',1,1);
insert into Orders values(2,\'10/09/2016\',\'09/30/2016\',2,2);
insert into PartOrder values(1,1,1,1);
insert into PartOrder values(2,2,2,1);

