Import. csv data into MySQL

1. First look at the data I need to import:

When opened with Excel, displays:

Open the display with notepad++ as:

2. Use notepad++ to open change character set to UTF-8

3, create a table, the fields in the table to be consistent with the file

3. Execute the command (my file is placed under local e-disk)

LOAD DATA LOCAL INFILE ' e:/ihg_ipy20180405135615_bi.csv '
Into TABLE ' Ihg_hotel '
Fields TERMINATED by ', ' optionally-enclosed by ' "' escaped by '" '
LINES TERMINATED by ' \ r \ n '

IGNORE 1 rows;--need to ignore one line, because my first row is the table header

Note that if you add the local parameter, users who do not have file permissions will report

Error 1045 (28000): Access denied for USER ' mip ' @ '% ' (USING password:yes) This bug

Import. csv data into MySQL