Database test - table agents running on localhost

Structure

Browse

SQL

Select

Insert

Export

Operations

Options

Empty

Drop

Location of the textfile
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.
[Documentation]