aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPSQLExporter.m
diff options
context:
space:
mode:
Diffstat (limited to 'Source/SPSQLExporter.m')
-rw-r--r--Source/SPSQLExporter.m8
1 files changed, 6 insertions, 2 deletions
diff --git a/Source/SPSQLExporter.m b/Source/SPSQLExporter.m
index d7a82666..ad16a119 100644
--- a/Source/SPSQLExporter.m
+++ b/Source/SPSQLExporter.m
@@ -427,8 +427,12 @@
if ((([self sqlInsertDivider] == SPSQLInsertEveryNDataBytes) && (queryLength >= ([self sqlInsertAfterNValue] * 1024))) ||
(([self sqlInsertDivider] == SPSQLInsertEveryNRows) && (k == [self sqlInsertAfterNValue])))
{
- [sqlString appendString:[NSString stringWithFormat:@");\n\nINSERT INTO %@ (%@)\nVALUES\n\t(", [tableName backtickQuotedString], [fieldNames componentsJoinedAndBacktickQuoted]]];
-
+ [sqlString appendString:@");\n\nINSERT INTO "];
+ [sqlString appendString:[tableName backtickQuotedString]];
+ [sqlString appendString:@" ("];
+ [sqlString appendString:[fieldNames componentsJoinedAndBacktickQuoted]];
+ [sqlString appendString:@")\nVALUES\n\t("];
+
queryLength = 0, k = 0;
// Use the opportunity to drain and reset the autorelease pool