作者dcplay01 (dcplay)
看板Database
标题Re: [SQL ] UPDATE 用法?
时间Thu Jan 24 21:05:10 2008
各位大大...想说 放在新的资料表一值都不行的话..
那我就只好放在旧的资料表上了@@
还是遇到问题..
UPDATE joinclass SET liberal_grade = avg( grade )
FROM JoinClass
WHERE course_id
LIKE "%l" OR course_id
LIKE "%a" OR course_id
LIKE "%n" OR course_id
LIKE "%p" AND 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
'FROM JoinClass WHERE course_id LIKE "%l" OR course_id LIKE "%
可是假如我把汇总函数 AVG 去除掉的话 就可以RUN.. 但是我是想计算平均..
没有汇总函数....就不能计算@@
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 125.229.213.241