报错,ERROR 1054 (42S22): Unknown column 'end_Time' in 'where clause'我一开始以为传入的参数出了问题,试着直接return tagName或者return endTime,但都能直接返回传入的参数值 where条件我直接写where id=345 也是返回ERROR 1242 (21000): Subquery returns more than 1 row 想不明白为什么
create function get_duration_seconds(tag_Name char(20),end_Time datetime) returns datetime deterministic begin declare beginTime datetime; declare result datetime; declare secs int; set beginTime=(select BeginTime from alarm_data where tag_name=tag_Name and EndTime=end_Time); return beginTime; end $这个是函数
where条件我直接写where id=345
也是返回ERROR 1242 (21000): Subquery returns more than 1 row
想不明白为什么
returns datetime
deterministic
begin
declare beginTime datetime;
declare result datetime;
declare secs int;
set beginTime=(select BeginTime from alarm_data where tag_name=tag_Name and EndTime=end_Time);
return beginTime;
end $这个是函数