CODEWITHSUNDEEP
mysqlcsv
Chetan
Chetan

Reputation: 51

How to insert records in mysql from csv?

How to use file load query?

I tried this query:

LOAD DATA INFILE 'customer.csv' INTO TABLE customer

Upvotes: 3

Views: 45

Answers (1)

Nashir Uddin
Nashir Uddin

Reputation: 748

Syntax:

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name' INTO TABLE `tbl_name` CHARACTER SET [CHARACTER SET charset_name] FIELDS [{FIELDS | COLUMNS}[TERMINATED BY 'string']] [LINES[TERMINATED BY 'string']]

Example:

LOAD DATA LOCAL INFILE 'E:\\wamp\\tmp\\customer.csv' INTO TABLE `customer` CHARACTER SET 'utf8' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'

Upvotes: 2

Related Questions