MySQL Forums
Forum List  »  Newbie

Re: How do i export a csv file?
Posted by: Dan Lores
Date: September 16, 2015 04:53AM

Try that

SELECT *
FROM tableName
INTO OUTFILE '/tmp/fileName.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'

Ability may get you to the top, but it takes character to keep you there. – John Wooden
http://www.kulturystyka.sklep.pl

Options: ReplyQuote


Subject
Written By
Posted
September 13, 2015 01:41PM
September 13, 2015 05:59PM
September 14, 2015 12:25PM
Re: How do i export a csv file?
September 16, 2015 04:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.