MySQL import CSV data in several ways

The MYSQL LOAD Data infile command can import data from a CSV flat file into the database.
If there is an import error, you should put the imported CSV file in the/tmp folder before you have any problems.

Method One, import data using the Load Data infile command

The code is as follows

Copy Code

Linux under: LOAD DATA INFILE '/tmp/fanhao.csv ' Into TABLE ip_location CHARACTER SET UTF8 FIELDS terminated by ', ' enclosed by ' '; --character Set:mysql Character Set, be sure to add, eliminate garbled trouble --into table: Which tables are imported into --fields terminated by: what as a separator --Enclosed by: what is surrounded by Windows: LOAD DATA INFILE "D:/fanhao.csv" REPLACE into TABLE DEMO CHARACTER SET gb2312 FIELDS terminated by "," enclosed by "" LINES terminated by "RN"; --lines terminated by: This differs from Linux in what is the end of a line.

Method two, using phpMyAdmin to import CSV data

1. Enter into a database to be imported we click on the following image

2. Then we click on the browse button below and we can select the CSV file.