質問編集履歴
1
解決方法の追加。
test
CHANGED
File without changes
|
test
CHANGED
@@ -59,3 +59,29 @@
|
|
59
59
|
・[https://mybatis.org/mybatis-3/ja/dynamic-sql.html](https://mybatis.org/mybatis-3/ja/dynamic-sql.html)
|
60
60
|
|
61
61
|
・[https://qiita.com/5zm/items/0864d6641c65f976d415](https://qiita.com/5zm/items/0864d6641c65f976d415)
|
62
|
+
|
63
|
+
|
64
|
+
|
65
|
+
##解決方法
|
66
|
+
|
67
|
+
CDATAを除外しましたら、エラーも発生せず、sqlを実行することができました。
|
68
|
+
|
69
|
+
```
|
70
|
+
|
71
|
+
<delete id="deleteById" parameterType="list">
|
72
|
+
|
73
|
+
DELETE FROM
|
74
|
+
|
75
|
+
tbl_schedule
|
76
|
+
|
77
|
+
WHERE task_id IN
|
78
|
+
|
79
|
+
<foreach item="item" index="index" collection="list" open="(" separator="," close=")">
|
80
|
+
|
81
|
+
#{item}
|
82
|
+
|
83
|
+
</foreach>
|
84
|
+
|
85
|
+
</delete>
|
86
|
+
|
87
|
+
```
|