0 votes
in MySQL by (5k points)
Exporting MySQL table data into a csv file.

1 Answer

0 votes
by (5k points)

For exporting MySQL table data into a csv file by using following mysql command:-

select name,emailId,mobileNo from userinfo where name='Ram' order id desc INTO OUTFILE '/tmp/user_detail.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

Share:- Whatsapp Facebook Facebook

Welcome to Developerhelpway Q&A, where you can ask questions and receive answers from other members of the community.