执行如下存储过程:
CREATE PROCEDURE `aa`()
BEGIN
call RealtimeData_9035();
call RealtimeData_9504();
call RealtimeData_9035();
end
报错信息如下:
Procedure execution failed
1146 - Table 'MonitorServer.user_detail_9035_20180201' doesn't exist
提示表不存在
修改存储过程为:
CREATE PROCEDURE `aa`()
BEGIN
DECLARE aa int DEFAULT 0;
DECLARE CONTINUE HANDLER for 1146 set aa=1 ;
call RealtimeData_9035();
call RealtimeData_9504();
call RealtimeData_9035();
end
执行存储过程成功