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






  1. SQL / MySQL
  2. Backup Load
  3. Save To Text File

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