SELECT * FROM t_stu s , t_course c ,t_stu_course sc WHERE s.sid = sc.sid AND c.cid = sc.cid;
1.jpg
SELECT s.sname,c.cname FROM t_stu s , t_course c ,t_stu_course sc WHERE s.sid = sc.sid AND c.cid = sc.cid;
2.jpg
SELECT * FROM t_stu s , t_course c ,t_stu_course sc WHERE s.sid = sc.sid AND c.cid = sc.cid;
1.jpg
SELECT s.sname,c.cname FROM t_stu s , t_course c ,t_stu_course sc WHERE s.sid = sc.sid AND c.cid = sc.cid;
2.jpg
本文标题:Mysql数据库外键设置和查询
本文链接:https://www.haomeiwen.com/subject/vcouaktx.html
网友评论