Syntax of LOAD DATA OUTFILE and SELECT .....INTO INFILE

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

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