Allow semicolon at the end of bulk insert query (PyMySQL#545)

alpha2wang · Feb 28, 2017 · 103a00d · 103a00d
1 parent 557d0d9
commit 103a00d
Showing 1 changed file with 1 addition and 1 deletion.
diff --git a/pymysql/cursors.py b/pymysql/cursors.py
@@ -14,7 +14,7 @@
 RE_INSERT_VALUES = re.compile(
     r"\s*((?:INSERT|REPLACE)\s.+\sVALUES?\s+)" +
     r"(\(\s*(?:%s|%\(.+\)s)\s*(?:,\s*(?:%s|%\(.+\)s)\s*)*\))" +
-    r"(\s*(?:ON DUPLICATE.*)?)\Z",
+    r"(\s*(?:ON DUPLICATE.*)?);?\s*\Z",
     re.IGNORECASE | re.DOTALL)