学生表的编码字段:
#--------
`CODE` varchar(20) character set utf8 NOT NULL COMMENT '条码',
`CODE` varchar(20) collate utf8_unicode_ci NOT NULL COMMENT '条码',
#--------
`CODE` varchar(20) character set utf8 NOT NULL COMMENT '条码',
#----------
老师表中的学生编码字段:
#--------`CODE` varchar(20) collate utf8_unicode_ci NOT NULL COMMENT '条码',
#--------
两表的code字段排序规则不同,导致code关联两表查询(select * from student s,teacher t where s.code =t.code)时出现错误:Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
解决方式:两者排序规则改为一致
altert table student modify `CODE` varchar(20) collate utf8_unicode_ci NOT NULL COMMENT '条码',