Exporting from MySQL : Export « Backup Load « SQL / MySQL





Exporting from MySQL

  
USE <database_name>;
SELECT *
INTO OUTFILE "<file_name.txt>"
FROM <table_name>;

           
       

Related examples in the same category

1.Exporting from MySQL indicating the terminator
2.Exporting from MySQL indicating ',' terminator