LOAD DATA INFILE '/tmp/test.txt' IGNORE INTO TABLE test PARTITION (p0, p1, p2) CHARACTER SET 'utf8' COLUMNS TERMINATED BY ',' LINES TERMINATED BY ';' IGNORE 1 LINES (col1, col2) SET @a = 1;