SQL/MySQL/Backup Load/Export

Exporting from MySQL

   <source lang="sql">
 

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

      </source>
   
  

Exporting from MySQL indicating "," terminator

   <source lang="sql">
 

USE <database_name>; SELECT * INTO OUTFILE "<file_name.csv>" FIELD TERMINATED BY "," FROM <table_name>;

      </source>
   
  

Exporting from MySQL indicating the terminator

   <source lang="sql">
 

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

      </source>