1.create_table.sql
CREATE TABLE IF NOT EXISTS `book`(
`name` VARCHAR(100) NOT NULL,
`author` VARCHAR(100) NOT NULL,
`year` VARCHAR(40) NOT NULL,
`publisher` VARCHAR(40) NOT NULL,
PRIMARY KEY ( `name` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
2.import_csv.sql(book1.csv.注意编码格式为utf8)
load data infile 'd:/md/book1.csv'
into table my_class
fields terminated BY ','
enclosed BY '"'
lines terminated BY '\n';
-- ignore 1 lines;