Export mysql table to file

Download Template
This is a simple way to select a table into a text file.

akonkol
April 4, 2012




select * 
       into outfile "%{path_to_file}%/%{filename}%" 
FIELDS TERMINATED BY '~~' 
LINES TERMINATED BY '&*'  
from %{database}%.%{table}%;

You must be logged in to comment.