select
statuses_id,
create_task_uid as `创建人`,
accept_uid as `接受人`,
evaluate_id,
from_unixtime(warn_time, '%Y-%m-%d %H:%i:%s') as `预警时间`,
from_unixtime(limit_time, '%Y-%m-%d %H:%i:%s') as `超时时间`,
status,
comments_id,
comments_created_at,
count(*)
from
tbl_task_warn as t where tbl_task_warn.statuses_id=8
group by statuses_id,accept_uid;如上面的SQL脚本,在mysql workbench 中如果出现了如group by等关键字会报错,出现了类似字段语法错误不报错,不知道该如何设置,求过来人指点。mysqlmysql workbench
select
statuses_id,
MIN(create_task_uid) as [创建人],
accept_uid as [接受人],
MIN(evaluate_id),
dbo.from_unixtime(min(warn_time), '%Y-%m-%d %H:%i:%s') as [预警时间],
dbo.from_unixtime(min(limit_time), '%Y-%m-%d %H:%i:%s') as [超时时间],
MIN(status),
MIN(comments_id),
MIN(omments_created_at),
count(*)
FROM tbl_task_warn as t
where statuses_id=8
group by statuses_id,accept_uid; --楼主没明白GROUP BY的意思:按statuses_id,accept_uid分组后,组内的其它字段只能取一个值.所以得用聚合函数,选一个。否则语法错误。
我的意思是workbench怎么设置才会提示错误,现在是有语法错误不提示