set @CurrentTime = NOW()
insert into
pa_history.painfo_history
(PAID
,ALLAREAS
,AREAPLAYING
,AREAREPEAT
,AREACOMPLETED
,PASTATUS
,INFORMATION
,SoundCardChannel
,VoiceMergeStatus
,NeedPlayFileName
,TheLastPlayEndTime
,FLIGHTID)
SELECT
PAID
,ALLAREAS
,AREAPLAYING
,AREAREPEAT
,AREACOMPLETED
,PASTATUS
,INFORMATION
,SoundCardChannel
,VoiceMergeStatus
,NeedPlayFileName
,TheLastPlayEndTime
,FLIGHTID
insert into
pa_history.painfo_history
(PAID
,ALLAREAS
,AREAPLAYING
,AREAREPEAT
,AREACOMPLETED
,PASTATUS
,INFORMATION
,SoundCardChannel
,VoiceMergeStatus
,NeedPlayFileName
,TheLastPlayEndTime
,FLIGHTID)
SELECT
PAID
,ALLAREAS
,AREAPLAYING
,AREAREPEAT
,AREACOMPLETED
,PASTATUS
,INFORMATION
,SoundCardChannel
,VoiceMergeStatus
,NeedPlayFileName
,TheLastPlayEndTime
,FLIGHTID
FROM pa.painfo
where (IFNULL(ltrim(rtrim(ALLAREAS)),””)=”” or ALLAREAS is null)
and (IFNULL(ltrim(rtrim(AREAPLAYING)),””)=”” or AREAPLAYING is null)
and (IFNULL(ltrim(rtrim(AREAREPEAT)),””)=”” or AREAREPEAT is null)
and TheLastPlayEndTime < DATE_ADD(@CurrentTime,INTERVAL -1 HOUR)
语句如上,在查询里面执行成功,但是放到事件里面保存的时候,一直弹框说有错误,如下图:
求指导决办法,谢谢!
解决方案
40
delimiter //
create event …
delimiter ;
create event …
delimiter ;