Save To Text File « Backup Load « SQL / MySQL






  1. SQL / MySQL
  2. Backup Load
  3. Save To Text File
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.To export the passwd table in CSV format with CRLF-terminated lines, use this statement:
18.Exporting Data Out of a Table