I want to load two flat-files (same format) into one table.
I was just curious if somehow I can use the same control-file
and just have two INFILEs
ie:
INFILE 'a.txt', 'b.txt'
otherwise I'll just make two control files.
thanks!
Printable View
I want to load two flat-files (same format) into one table.
I was just curious if somehow I can use the same control-file
and just have two INFILEs
ie:
INFILE 'a.txt', 'b.txt'
otherwise I'll just make two control files.
thanks!
Yes you can here is the syntax :
load data
INFILE 'a.txt'
INFILE 'b.txt'
insert into table ...
...