[eluser]Unknown[/eluser]
I am using an Ubuntu server.
This is the error I get when I try to add data to the table, under the first record "TelType":
INSERT INTO `School`.`Instructor-Tel` (`TelType`, `TelNumber`) VALUES (home, 3058887452)
1054: Unknown column 'home' in 'field list'
THIS IS THE CODE:
-- -----------------------------------------------------
-- Table `School`.`Instructor-Tel`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `School`.`Instructor-Tel` (
`TelType` VARCHAR(50) NULL ,
`TelNumber` INT NULL ,
`Instructors_InstID` INT NOT NULL ,
PRIMARY KEY (`Instructors_InstID`) ,
CONSTRAINT `fk_InstTelph_Instructors1`
FOREIGN KEY (`Instructors_InstID` )
REFERENCES `School`.`Instructors` (`InstID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
Any help is greatly appreciated!