Software >> Services >> RDBMS >> MySQL >> Administration >> How to export or extract rows from a table to a file

(1) my exporting from mysql command line mysql> SELECT * > FROM <table> > INTO OUTFILE 'file path' > FIELDS TERMINATED BY '|'; will select all columns from table <table> and save the output into <filename> example 1: SELECT * FROM CategoryInformation INTO OUTFILE 'c:\CategoryInformation.csv' FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\' LINES TERMINATED BY '\r\n'