MySQL Bulk Import CSV file

Note the encoding consistency, such as: My database is UTF-8 encoding, CSV document encoding is also utf-8.

Import use LOAD DATA LOCAL INFILE For detailed usage please refer to documentation or books.

MySQL User table structure:

+----------+-------------+------+-----+---------+----------------+| Field    | Type        | Null | Key | Default | Extra          |+----------+-------------+------+-----+---------+----------------+| uid      int( One )     | NO   | PRI | NULL    | auto_increment | | username | varchar | NO   |     | NULL    |                | | password | varchar| NO   |     | NULL    |                | +----------+-------------+------+-----+---------+----------------+

Generated CSV file format:

Tom,tompassword,lili,lilipassword,

Perform the Import

' D:/database.csv ' User ' , ' ' " ' (' username ', ' password ');

The red part refers to: File path, table, field.

MySQL Bulk Import CSV file