Home > database >  The load data local infile - mysql import field is how to deal with in Chinese
The load data local infile - mysql import field is how to deal with in Chinese

Time:10-01

mysql CSV import statements:
The load data local infile 'D:/upload/TMP/4 g/20170104080200. The CSV' into table lte_cell_day_hw fields terminated by ', 'enclosed by' "' lines terminated by '
'IGNORE 7 LINES (' date', 'the name of the base station,' village name ', 'village duplex mode', 'community ID')
: database for Chinese field (because field, too much to see and show clearly, has been the naming and CSV header), after the execution has been an error: You have an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near 'date', 'base station name', 'community name', 'village duplex mode', 'community ID' at line 1
Could you tell me the load database field how to deal with import Chinese;
  • Related