mySQL: Export table to pipe delimited file - Simplest way to to export a MySQL table to a pipe delimited file.

Quick Search:

mySQL: Export table to pipe delimited file

Jump to:

Snippet Name: Export table to pipe delimited file

Description: Simplest way to to export a MySQL table to a pipe delimited file.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

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