Announcement

Announcement Module
Collapse
No announcement yet.

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

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #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

    Comment

    Working...
    X