Mysql error 1054: Unknown column 'home' in 'field list' - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: Mysql error 1054: Unknown column 'home' in 'field list' (/showthread.php?tid=50967) |
Mysql error 1054: Unknown column 'home' in 'field list' - El Forum - 04-15-2012 [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! Mysql error 1054: Unknown column 'home' in 'field list' - El Forum - 04-15-2012 [eluser]TWP Marketing[/eluser] Teltype is a varchar, so make the value a string: 'home' Mysql error 1054: Unknown column 'home' in 'field list' - El Forum - 04-16-2012 [eluser]Reneesh T K[/eluser] INSERT INTO `School`.`Instructor-Tel` (`TelType`, `TelNumber`) VALUES ('home', 3058887452) Mysql error 1054: Unknown column 'home' in 'field list' - El Forum - 04-16-2012 [eluser]Unknown[/eluser] Thanks a lot, I was able to figure it out based on your suggestions. :-) |