作者Catbert (宅男)
看板Database
標題Re: [SQL ] UPDATE 用法?
時間Thu Jan 24 17:10:31 2008
※ 引述《dcplay01 (dcplay)》之銘言:
: 我用
: UPDATE calculate SET liberal_grade= 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
上面的改成下面這段試試^^"
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
)
試試^^"
--
沒事多灌水...
多灌水沒事...
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 221.169.7.130
推 starjou:MySQL 要取 alias 需要 AS 關鍵字,我不知道能不能省略 01/24 17:28
推 dcplay01:報告大大....結果跟..JAMESWIKI大大的結果一樣.... 01/24 17:44