MySQL の LOAD DATA で関数や計算式をかます

$ cat data.txt
1	a
2	b
3	c

CREATE TABLE xx
(
  id INT NOT NULL PRIMARY KEY,
  ss VARCHAR (255) NOT NULL
);

LOAD DATA LOCAL INFILE 'data.txt' INTO TABLE xx (@id, @ss)
  SET id = @id * 2, ss = UPPER(@ss);

SELECT * FROM xx;
/*
+------+------+
| id   | ss   |
+------+------+
|    2 | A    |
|    4 | B    |
|    6 | C    |
+------+------+
*/