1、多对一处理 association
查询多个学生对应一个老师
构建一对多的表,sql语句如下(特别注意这个引号,不是单引号)
create table `teacher` (
`id` int(10) not null primary key,
`name` varchar(50) default null
) engine=InnoDB default charset=utf8
实测OK
create table `student` (
`id` int(10) not null primary key,
`name` varchar(50) default null,
`tid` int(10) default null,
CONSTRAINT `fktids` FOREIGN KEY (`tid`) REFERENCES `teacher` (`id`)
)engine=innodb default charset=utf8
定义一个名称为【fktids】的外键,外键字段【tid】,关联的是teacher表的【id】字段,实测OK
insert into teacher (id,name