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>