For When You Can't Have The Real Thing
[ start | index | login ]
start > mysql > CSV output

CSV output

Created by dave. Last edited by dave, 15 years and 31 days ago. Viewed 3,026 times. #1
[edit] [rdf]
labels
attachments

Comma Separated Values format for MySQL Data

mysql> SELECT * INTO OUTFILE '/tmp/result.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM response_answers;
no comments | post comment
see also:
snipsnap-index ... dave Top 10 Applications, 2009
mysql snipsnap-index Top+10+Applications,+2009 Netscreen
VLAN definition find+a+process... Router ARP Tables Juniper
iozone dtgreet+hack Find+a+process... convert Hex MAC t...
dtgreet hack Power Connect 622... VNC Co... Configuring Manage...

Virtual Dave Megaplex:

(read this note about local search)

Logged in Users: (0)
… and 3 Guests.

Recently Changed

Editing: snipsnap-help, Image Macro

(Et auditum est, et idcirco ego nunc simulare)

This is a collection of techical information, much of it learned the hard way. Consider it a lab book or a /info directory. I doubt much of it will be of use to anyone else.

Useful:

snipsnap.org | Copyright 2000-2002 Matthias L. Jugel and Stephan J. Schmidt