Mysql: 错误代码:1054 Unknown column ’ ’ in ‘field list’
CREATE TABLE `teacher`(
`id` INT(8) NOT NULL,
`name` VARCHAR(20) DEFAULT NULL,
PRIMARY KEY(`id`)
)ENGINE=INNODB DEFAULT CHARSET=utf8
CREATE TABLE `student`(
`id` INT(10) NOT NULL,
`name` VARCHAR(20) DEFAULT NULL,
`tid` INT(10) DEFAULT NULL,
PRIMARY KEY(`id`),
KEY `fktid` (`tid`),
CONSTRAINT `fktid` FOREIGN KEY(`tid`) REFERENCES `teacher`(`id`)
)ENGINE=INNODB DEFAULT CHARSET=utf8
INSERT INTO `student`(`id`,`name`,`tid`) VALUES(`2`,"小李",`1`);
错误代码: 1054
Unknown column '2' in 'field list'
原因如下:
正确的做法: