Backup table records into txt file: indicate terminator : Save To Text File « Backup Load « SQL / MySQL






Backup table records into txt file: indicate terminator

  
Drop table CDs;

CREATE TABLE CDs (
   CDID SMALLINT NOT NULL PRIMARY KEY,
   CDName VARCHAR(50) NOT NULL,
   InStock SMALLINT UNSIGNED NOT NULL,
   Category VARCHAR(20)
);


INSERT INTO CDs
VALUES (101, 'Blood', 10, 'Rock'),
       (102, 'Jazz', 17, 'Jazz'),
       (103, 'Class', 9, 'Classical'),
       (104, 'Violin', 24, NULL),
       (105, 'Blues', 2, 'Blues'),
       (106, 'Tires', 12, 'Country'),
       (107, 'Essence', 5, 'New Age'),
       (108, 'Magic', 42, 'Classical'),
       (109, 'Name', 20, 'Opera'),
       (110, 'Fire', 23, 'Country'),
       (111, 'Live', 18, 'Jazz'),
       (112, 'Blues', 22, 'Blues'),
       (113, 'Stages', 42, 'Blues');
  
  
  
SELECT CDName, InStock, Category INTO OUTFILE 'Backup.sql'
   FIELDS
      TERMINATED BY ','
      ENCLOSED BY '*'
FROM CDs WHERE Category='Classical';
           
         
    
  








Related examples in the same category

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