Find knowledge base article(s) by searching for keywords in the title e.g. type linux in the search box below
Find knowledge base article(s) by browsing the subject categories of articles
Technology quick references, cheatsheets, user manuals etc.
Shop Online through ShopifyLite
Tutorials on various IT applications.
Search Title    (UL:0 |SS:f)

Software >> Services >> RDBMS >> MySQL >> Command Line >> What is the syntax of the LOAD DATA command to import a file

LOAD DATA LOCAL INFILE 'c:\home\gmp\public_html\_export\file.csv' INTO TABLE TableName FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\' LINES TERMINATED BY '\r\n' IGNORE 1 LINES"; sYNTAX: LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] [IGNORE number LINES] [(col_name,...)]
[ © 2008-2021 myfaqbase.com - A property of WPDC Consulting ]