Backup A Table To CSV File

Submitted by:Andery Smith

Date added:09 October, 2011

Category:MySQL

This code shows how to backup a table to a CSV file.

Tags: mysql backup , backup as csv

Code Snippet:

SELECT *
INTO OUTFILE "C:/backup.csv"
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
FROM category
 
 

Comments