mysql load data 博客分类： mysql

LOAD DATA LOCAL INFILE '/Users/Peter.Dong/Downloads/DEP2017082100006.100448.150.csv'

INTO TABLE `transport_region`

character set UTF8

FIELDS ESCAPED BY '\\'

TERMINATED BY ','

ENCLOSED BY '"'

LINES TERMINATED BY '\n'

(

  `REGIONAL_TRANSPORT_CODE`,

  `REGIONAL_TRANSPORT_NAME`,

  `REGIONAL_TRANSPORT_LEVEL`,

  `PARENT_REGIONAL_TRANSPORT_CODE`,

  `VERSION_NO`,

  `DELETE_FLAG`,

  `UPDATE_TIME`

);