About LOAD INTO OUTFILE.

[vgokulraj]

Hi,

I had a problem while executing the following query.

select * INTO OUTFILE 'c:\sample.txt' from userAccount;

The query executed fine. But the file is not stored any where?
Acutall where sample.txt? I need ur help.

Thank u
Regards
V. Gokulraj

[Banfa]

Where (on what computer) is this query executing?

[vgokulraj]

Hi,
Thank you for reply. Now i got the file. Actully i logged in to another user from my PC.
whenever i execute the query from my pc, the file saved in that user pc(location mysal/data/database folder) not in my pc.

Thanks & Regards
V. Gokulraj

[vssp]

Good vgokulraj

Can you send me how to store the field sample.txt?

[vgokulraj]

Hi,

I don't know to add the fields with "SELECT * INTO OUTFILE FROM TABLE".

The another option load the data into file with fields is using command line.

c:\> mysql -u user_name -p database_name -e "select concat(column1, ',' , column2, ',', colomn3....) as 'column1,column2,column3...' from table" ; >>sample.txt

thank you
V. Gokulraj

[vssp]

Thanks gokulraj