To export the passwd table in CSV format with CRLF-terminated lines, use this statement: : Save To Text File « Backup Load « SQL / MySQL

To export the passwd table in CSV format with CRLF-terminated lines, use this statement:

        



SELECT * FROM passwd INTO OUTFILE '/tmp/passwd.txt'

FIELDS TERMINATED BY ',' ENCLOSED BY '"'

LINES TERMINATED BY '\r\n';

Related examples in the same category

1.	Backup records into txt file
2.	Backup table records into txt file: indicate terminator
3.	Set OPTIONALLY ENCLOSED
4.	set ENCLOSED terminator
5.	Escape sign
6.	Create dump file
7.	Add null value to dumped file
8.	Dump data into a text file
9.	Dump data into text file and change the default terminators
10.	Change the terminator for fields
11.	Change the ternimator for lines
12.	Exporting Data to a Dump File
13.	Adding an ESCAPED BY subclause:
14.	LINES subclauses.
15.	To put the rows on separate lines, you must modify the TERMINATED BY subclause
16.	Terminates each line with <>
17.	Exporting Data Out of a Table

All other trademarks are property of their respective owners.