The resulting
file is bigger, but will prove more portable on various SQL systems, with the
added benefit of being better documented.
Extended inserts: Packs the whole table data into a single INSERT statement:
INSERT INTO 'author' VALUES (1, 'John Smith',
'+01 445 789-1234'), (2, 'Maria Sunshine', '+01 455 444-5683');
This method of inserting data is faster than using multiple INSERT
statements, but is less convenient because it makes reading the resultant file
harder. Extended inserts also produces a smaller file, but each line of this
file is not executable in itself because each line does not have an INSERT
statement. If you cannot import the complete file in one operation, you
cannot split the file with a text editor and import it chunk by chunk.
Maximal length of created query: The single INSERT statement generated
for Extended inserts might become too big and could cause problems, this
is why we can set a limit here??”in number of characters??”for the length of
this statement.
Use delayed inserts: Adds the DELAYED modifier to INSERT statements. This
accelerates the INSERT operation because it is queued to the server, which
will execute it when the table is not in use. Please note that this is a MySQL
non-standard extension, and it's only available for MyISAM, ISAM, MEMORY
and ARCHIVE tables.
Use ignore inserts: Normally, at import time, we cannot insert duplicate
values for unique keys??”this would abort the insert operation.
Pages:
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131