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