Outfile to 'result.csv'

[harikrishna439]

Hi.......
While I create a outfile as in format of csv...

I am using the command

select * from table_name into outfile 'result.csv';

I am getting all properties(field) of a record into one shell in excel..

Is there anyway I can get each property in different shells...

Any answer could be appreciated...........

[debasisdas]

try the fiollowing

SELECT * INTO OUTFILE 'result.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM table_name;

also read this.

[harikrishna439]

Thank you sir,

But I'm not getting this properly means all the table represented in one column of excel......But I don't want like that...Each attribute should place in different columns of excel...

So please post the script that represents above condition...........