[SQL ] UPDATE 用法?
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
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
上面這段可以查詢
可是我想套用上面的查詢結果 放在新的資料表calculate 的liberal_grade欄位名稱上
我用
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
卻出現
#1064 - You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version
for the right syntax to use near '( grade )
FROM JoinClass j1 JOIN calculate c1 ON j1.
可是我用簡易的計算就可以
例如 UPDATE calculate SET M1=(M2+M3)/2 where stu_id=93101163
套用到資料表 FROM 就不太行.. 麻煩大大解惑.. 比較少用到UPDATE...
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 125.229.198.133
討論串 (同標題文章)
以下文章回應了本文 (最舊先):
完整討論串 (本文為第 1 之 13 篇):