Re: [SQL ] UPDATE 用法?
※ 引述《Catbert (宅男)》之銘言:
: 上面的改成下面這段試試^^"
: UPDATE calculate
: SET liberal_grade=
: (
: SELECT avg(grade)
: FROM JoinClass j1 JOIN calculate c1 ON j1.stu_id = c1.stu_id
: WHERE course_id LIKE "%l" OR
: course_id LIKE "%a" OR
: course_id LIKE "%n" OR
: course_id LIKE "%p" AND
: j1.stu_id =93101163
: )
: 試試^^"
本板的重覆推文時間也隔太久了 XD
完整的語法是 FROM table1_name AS table1_alias JOIN table2_name AS table2_alias
ON table1_alias.field_name = table2_alias.field_name ...
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 219.80.137.188
推
01/24 17:37, , 1F
01/24 17:37, 1F
討論串 (同標題文章)
本文引述了以下文章的的內容:
完整討論串 (本文為第 5 之 13 篇):