在學(xué)校學(xué)過SQL,無意間發(fā)現(xiàn)了這個課程,就隨手打開看了看,發(fā)現(xiàn)講的很好,知道了很多細(xì)節(jié)方面的東西。我二倍速看的,覺著很易懂。
2018-11-30
select t2.ci_id, wm_concat(t1.stu_name)
from pm_stu t1, pn_ci t2
where instr(t2.stu_ids, t1.stu_id) > 0
group by t2.ci_id
看看提示還是挺簡單的
from pm_stu t1, pn_ci t2
where instr(t2.stu_ids, t1.stu_id) > 0
group by t2.ci_id
看看提示還是挺簡單的
2018-11-02
select cid,wm_concat(name) from ci,pm where instr(ci.sid,pm.sid)>0 group by cid;
2018-11-01
select c.ci_id,(select wm_concat(stu_name) from pm_stu s where instr(c.stu_ids,s.stu_id)>0) stu_names
from pm_ci c
from pm_ci c
2018-08-28
select c.ci_id,wm_concat(s.stu_name) from pm_stu s,pm_ci c
where instr(c.STU_IDS,s.STU_ID)>0
group by c.ci_id;
where instr(c.STU_IDS,s.STU_ID)>0
group by c.ci_id;
2018-08-24