提取文件中所有SQL代码,并整理
时间: 2024-09-30 14:08:39 浏览: 16
以下是文件 `new 23.txt` 中出现的所有 SQL 代码:
### SQL 语句列表
#### 数据初始化 SQL 文
1. **删除出口勤务2集计表格数据**
```sql
DELETE FROM KMD_OUT_SUM2
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
2. **删除车种别轴数别台数表格数据**
```sql
DELETE FROM KMD_SYA_JIK
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
3. **删除勤务明细_特处理表格数据**
```sql
DELETE FROM KMD_KNM_TOK
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
4. **删除勤务明细_再发行表格数据**
```sql
DELETE FROM KMD_KNM_SAI_HAK
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
5. **删除事务所_特处理表格数据**
```sql
DELETE FROM KMD_KNM_JIM_TOK
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
6. **删除事务所_IC车载器表格数据**
```sql
DELETE FROM KMD_KNM_JIM_IC
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
7. **删除事务所_无效别纳表格数据**
```sql
DELETE FROM KMD_KNM_JIM_MKO_BET
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
8. **删除事务所_时间超过表格数据**
```sql
DELETE FROM KMD_KNM_JIM_TIM_OVR
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
9. **删除勤务明细_船车票表格数据**
```sql
DELETE FROM KMD_KNM_SENSYA
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
10. **删除勤务明细_驻留军免费证明表格数据**
```sql
DELETE FROM KMD_KNM_AMY_MRY
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
11. **删除勤务明细_障碍者表格数据**
```sql
DELETE FROM KMD_KNM_SYOGAI
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
12. **删除勤务明细_别纳表格数据**
```sql
DELETE FROM KMD_KNM_BETUNO
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
13. **删除勤务明细_LANE服务信号表格数据**
```sql
DELETE FROM KMD_KNM_LANE_SRV_SIGNAL
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
14. **删除勤务明细_海卡表格数据**
```sql
DELETE FROM KMD_KNM_HICA
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
15. **删除勤务明细_认定表格数据**
```sql
DELETE FROM KMD_KNM_NINTEI
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
16. **删除事务所处理表格数据**
```sql
DELETE FROM KMD_JIM_SYO
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
17. **删除入口勤务集计修正数据表格数据**
```sql
DELETE FROM KMS_IN_SUM
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
18. **删除出口勤务集计修正数据表格数据**
```sql
DELETE FROM KMS_OUT_SUM
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```
19. **删除出口勤务明细修正数据表格数据**
```sql
DELETE FROM KMS_OUT_KIN
WHERE
H_ICNO = ?
AND H_KINMU_DATE >= ?
```