http://dev.mysql.com/doc/refman/5.0/en/select.html
http://dev.mysql.com/doc/refman/5.0/en/select-into.html
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
...
FIELDS TERMINATED BY '|'
...
Lots of examples:
http://forums.mysql.com/read.php?10,512947 (select ... into outfile)
http://forums.mysql.com/read.php?10,508812 (Filter and export mysql data by script)
http://forums.mysql.com/read.php?98,507110 (Select INTO OUTFILE not working in procedure)
http://forums.mysql.com/read.php?10,504002 (How do I get last inserted row from MySQL table?)
http://forums.mysql.com/read.php?10,498614 (Automate Creation/Export of CSV?)
http://forums.mysql.com/read.php?10,494079 (Problems with Load DATA INFILE and INSERT INTO)
http://forums.mysql.com/read.php?10,444231 (Re: multiple sql script output data in CSV)
http://forums.mysql.com/read.php?10,430395 (Adding an ORDER BY syntax kills this query?)
http://forums.mysql.com/read.php?10,428670 (Please help using OUTFILE in mysql..)
http://forums.mysql.com/read.php?98,426621 (prepared 'select into outfile' with delimiters)
http://forums.mysql.com/read.php?98,425238 (Store Output Results From a SELECT query From a Stored Procedure)
http://forums.mysql.com/read.php?10,419881 (Outfile with CURDATE error.)
http://forums.mysql.com/read.php?10,419431 (update table after where clause)
http://forums.mysql.com/read.php?10,417060 (Problem with exporting ,)
http://forums.mysql.com/read.php?21,408177 (Slow Performance CPU not increase)
http://forums.mysql.com/read.php?10,407917 (Illegal Characters)
http://forums.mysql.com/read.php?22,406382 (How can I 'attach' a MySQL database ?)
http://forums.mysql.com/read.php?20,405046 (select into file problem...)
http://forums.mysql.com/read.php?52,401329 (giving input to execute .sql file from .bat file)
http://forums.mysql.com/read.php?52,400510 (select into outfile when webserver and DB server are two different machines)
http://forums.mysql.com/read.php?98,394854 (Stored Procedure Screwiness)
http://forums.mysql.com/read.php?10,393839 (data export)
http://forums.mysql.com/read.php?10,390774 (Multiple Queries Run from Query Browser and result store in miltiple csv files query wise)
http://forums.mysql.com/read.php?10,388686 (Script Editor, Temp table, and Export to CSV)
http://forums.mysql.com/read.php?10,386665 (Export to CSV in local host)