mysql在查询中常见问题汇总

从主从表中查询对应的外键，需要指定外键的表，即sno=》 student.sno或者score.sno

错误：select sno,sname,degree from student,score where student.sno=score.sno;

正确：select student.sno,sname,degree from student,score where student.sno=score.sno;

mysql在查询中常见问题汇总

标签：name   pos   font   blog   div   gpo   str   常见   img