DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Web has posted 8 posts at DZone. View Full User Profile

Export A MySQL Table To A Pipe Delimited File

12.11.2008
| 5756 views |
  • submit to reddit
        // how to export a MySQL table to a pipe delimited file

SELECT * FROM TABLE ORDER BY ID INTO OUTFILE 'out.file' FIELDS TERMINATED BY '|';