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...........

try the fiollowing

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

also read this.

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...........

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.