MySQL Forums
Forum List  »  General

mySQL export to text
Posted by: NOT_FOUND NULL !
Date: November 03, 2018 01:20PM

Need a hand with mySQL export to text. If I do a command line query (windows not linux) I get pretty output like this:
+-----------+------------+
| LAST_NAME | FIRST_NAME |
+-----------+------------+
| Jordan | Todd |

which the forum may mess up, but which looks quite neat and clean on the screen.
If I pipe the output to more, or append (>>) to a text file I loose the spacing and ascii characters and it looks like hell.

Anyone know a trick to get the nice output to a text file? I really don't want to send it to CSV and then rework the data to be pretty when mySQL can clearly handle the formatting for me.

Options: ReplyQuote


Subject
Written By
Posted
mySQL export to text
November 03, 2018 01:20PM
November 03, 2018 03:58PM
November 03, 2018 09:46PM
November 04, 2018 08:40AM


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.