Mega Code Archive

 

Categories / MySQL / Backup Load

 

Exporting from MySQL indicating , terminator

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