Exporting A Table To A CSV Text File .: Mustang Internet Services Knowledge Base

Mustang Internet Services Knowledge Base	Glossary Contact Us
Return to MustangInternetServices.com Home Page

Mustang Internet Services Knowledge Base .: MySQL .: Working With Files .: Exporting A Table To A CSV Text File

Exporting A Table To A CSV Text File

Example of how to export a table to a CSV text file:

SELECT * INTO OUTFILE '/path/FileName.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY 'n'
FROM tableName.

Load Data From File Into Table
Example syntax to load CSV file:LOAD DATA...
(No rating) 2-11-2005 Views: 426

No comments have been posted.