一、创建表
CREATE TABLE IF NOT EXISTS `tablename`(
`columnname1` INT UNSIGNED AUTO_INCREMENT,
`columnname2` VARCHAR(100) NOT NULL,
`columnname3` VARCHAR(40) NOT NULL,
`columnname4` DATE,
PRIMARY KEY ( `columnname1` )
);
二、导入csv
LOAD DATA INFILE 'C:/a.csv' INTO TABLE tablename
CHARACTER SET utf8
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
[(columnname1,columnname2,columnname3,columnname4)];