CREATE TABLE table1 (
`Id` int(11) NOT NULL,
`url` varchar(256) NOT NULL
PRIMARY KEY (`Id`)
) ENGINE=InnoDB
# table1.csv
id,url
1,http://ya.ru
2,http://google.com
3,http://bing.com
LOAD DATA LOCAL INFILE 'table1.csv'
-> INTO TABLE table1
-> FIELDS TERMINATED BY ','
-> LINES TERMINATED BY '\n'
-> IGNORE 1 LINES
-> (id, url);