Re: [SQL ] UPDATE 用法?
用這個試試
1.在SQL server中可run,mySQL..粉久不用了..你要試試,改成mySQL可用的語法
2.學號要不要加引號,看你的資料型別,我只給你可以跑的"樣式"
3.記得最後要加上where條件,不然其他calculate->liberal_grade的值都會變NULL或0
====================================================================
update calculate set liberal_grade= case stu_id
when '93101163'
then
(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')
end
where stu_id='93101163'
==============================================================
※ 引述《dcplay01 (dcplay)》之銘言:
: DBMS MySQL Database Version 4.0.16
: phpMyAdmin Database Manager Version 2.5.4
: SELECT avg(grade)
: FROM JoinClass j1
: JOIN calculate c1 ON j1.stu_id = c1.stu_id
<恕刪>
※ 編輯: jameswiki 來自: 220.134.154.61 (01/24 05:39)
討論串 (同標題文章)
本文引述了以下文章的的內容:
完整討論串 (本文為第 2 之 13 篇):