| | |
| | | @Insert(" INSERT INTO ${tableName} SELECT * FROM ${lastTableName} WHERE CollectTime < '${date}' ") |
| | | void insertTableData(@Param("tableName") String tableName, @Param("lastTableName") String lastTableName, @Param("date") String date); |
| | | |
| | | @Delete(" delete from ${tableName} where CollectTime < '${day}' ") |
| | | @Delete("delete from ${tableName} where CollectTime < '${day}' ") |
| | | void deleteTableData(@Param("tableName") String saveTableName, @Param("day") String day); |
| | | |
| | | @Insert("CREATE TABLE `{tableName}` AS SELECT * FROM `{lastTableName}` WHERE CollectTime < '${date}' ") |