作者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
1F：推 starjou:MySQL 要取 alias 需要 AS 关键字，我不知道能不能省略 01/24 17:28
2F：推 dcplay01:报告大大....结果跟..JAMESWIKI大大的结果一样.... 01/24 17:44