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

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

Announcement

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

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

Comment