please help…
I want the format of performing LOAD DATA OUTFILE to select a table data into a .txt/.xls file.
Also I heard about SELECT…INTO INFILE loading a .txt file into a table.
They are quite opposed to the format of LOAD DATA INFILE and SELECT …INTO OUTFILE.
Kindly do the favour…
Thanks to one & all
posner
2
Kamal4perc
what do mean by
They are quite opposed to the format of LOAD DATA INFILE and SELECT …INTO OUTFILE.
load data outfile
If u want this
I want the format of performing LOAD DATA OUTFILE to select a table data into a .txt/.xls file.
select * from table
into outfile '/home/dir1/dir2/file.txt’fields terminated by ‘\t’;
for this
Also I heard about SELECT…INTO INFILE loading a .txt file into a table.
load data local infile ‘/home/dir1/dir2/file.txt’ into table table_name fileds terminated by ‘\t’;
i dont think there is load data outfile
did u mean load data infile
similarly it is select …into outfile