vgrabovets
10/10/2016 - 2:06 PM

load data

load data

CREATE TABLE test.user_cartoons_ru (
  user_id int(15) NOT NULL,
  n int(6) NOT NULL,
  time_min int(10) NOT NULL,
  PRIMARY KEY (user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


LOAD DATA LOCAL INFILE 'D:/Documents/megogo/children/ru.csv' 
INTO TABLE test.user_cartoons_ru 
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
IGNORE 1 LINES;