Server:
mysql.puroparty.com
Database:
puroparty
Table:
wp_2_term_relationships
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Location of the textfile
(Max: 2,048KB)
Replace table data with file
Replace
The contents of the file replaces the contents of the selected table for rows with identical primary or unique key.
Fields terminated by
The terminator of the fields.
Fields enclosed by
OPTIONALLY
Often quotation marks. OPTIONALLY means that only char and varchar fields are enclosed by the "enclosed by"-character.
Fields escaped by
Optional. Controls how to write or read special characters.
Lines terminated by
Carriage return: \r
Linefeed: \n
Column names
If you wish to load only some of a table's columns, specify a comma separated field list.
LOAD method
...DATA
...DATA LOCAL
The best method is checked by default, but you can change if it fails.