运行sql语句出错:[Err] 2014 - Commands out of sync; you can‘t run this command now

联表查询语句

内连接

select d.id,d.alarmTime,d.alarmRecoveryTime,s.alarmSort,s.alarmType,s.alarmSubType,s.alarmDescription,s.alarmLevel,s.remarks from
 (select * from d_tsrs_history_alarm where 1=1 and alarmTime >= 1594105463672 and alarmTime<=1594877078562 and alarmRecoveryTime is not null limit 4 ) d 
inner join s_alarm_info s on d.alarmTypeId=s.alarmTypeId and d.alarmSubTypeId=s.alarmSubTypeId and d.alarmDescriptionId=s.alarmDescriptionId 

报错

[Err] 2014 - Commands out of sync; you can’t run this command now

原因竟然是窗口失效了,重新打开一个窗口运行就ok

©️2020 CSDN 皮肤主题: 游动-白 设计师:上身试试 返回首页