This option
adds the IGNORE modifier to INSERT and UPDATE statements, thus skipping
the rows which generate duplicate key errors.
Use hexadecimal for BLOB: This option makes phpMyAdmin encode
the contents of BLOB fields in 0x format. Such a format is useful because,
depending on the software that will be used to manipulate the export file
(for example a text editor or mail program), handling a file containing 8-bit
data can be problematic. However, using this option will produce an export
of the BLOB that can be twice the size or even more.
???
???
???
???
???
???
Chapter 7
[ 123 ]
Export type: The choices are INSERT, UPDATE, and REPLACE. The most
well-known of these types is the default INSERT??”using INSERT statements
to import back our data. At import time, however, we could be in a situation
where a table already exists and contains valuable data, and we just want
to update the fields that are in the current table we are exporting. UPDATE
generates statements like UPDATE 'author' SET 'id' = 1, 'name' = 'John
Smith', 'phone' = '111-1111' WHERE 'id' = '1'; updating a row when
the same primary or unique key is found. The third possibility, REPLACE,
produces statements like REPLACE INTO 'author' VALUES (1, 'John
Smith', '111-1111'); which act like an INSERT statement for new rows
and updates existing rows, based on primary or unique keys.
Pages:
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132