Thursday, January 6, 2011

Mysql data unload

Use the following SQL to unload data from Mysql server without executing command. This method is good for very large set of data.

select * from table into outfile "file.txt"


Note :- file.txt will be created at"MySQL/data/database" directory.