修改删除超时的历史实时数据表数据库错误bug

whyclj

2020-12-23 84f92845f7969fb899dc0fda8cea2edff46a9496

修改删除超时的历史实时数据表数据库错误bug

 Central_Monitor/src/com/data/history/Central_Data_RealRecord_Thread_SQL.java

@@ -163,7 +163,7 @@
    public static void deleteHistoryData(MysqlConnPool conn_pool,Date deldate) {

        String sql_select_strs = " select TABLE_NAME,UPDATE_TIME,CREATE_TIME " + 

                                 " from information_schema.tables " + 

                                 " where table_schema='db_watersystem' " + 
                                 " where table_schema='db_3.5mw_motor_history' " + 
                                 " AND TABLE_NAME like 'tb_central_monitor_sys_%' " + 

                                 " AND CREATE_TIME <= '"+Com.getDateTimeFormat(deldate, Com.DTF_YMDhms)+"';" ;

        String sql_delete_strs = " DROP TABLE IF EXISTS ";