A sample control file for loading blob data:
load data
infile 'test_lob.dat'
append into table test_lob
fields terminated by ','
(id , name, external_filename FILLER,
name_lob LOBFILE(external_filename) TERMINATED BY EOF
)
The data in test_lob.dat has
1,'Tamilselvan',tamil.jpg
2,'Kannan',Kannan.jpg




Reply With Quote