sql - Load data from two (or more) files into one table -

i have 1 table:

create table t (   id int not null primary key,   x int not null,   y int not null ); 

the data in 2 files: 1 file has (id, x) value pairs , file has (id, y) value pairs. there 20 million rows in each. of id values appear in x file appear in y file , visa versa.

can suggest how load id, x , y values 2 files t?

if on unix machine may have access "join" can join 2 files , produce them on stdout. bulk load standard out directly mysql. reduce number of writes disk.