Backup file indicating line and record separator : Backup Table « Table Index « SQL / MySQL






  1. SQL / MySQL
  2. Table Index
  3. Backup Table

Backup file indicating line and record separator

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 'CDsOut.txt'
   FIELDS
      TERMINATED BY ','
      ENCLOSED BY '\"'
   LINES
      TERMINATED BY '<<end>>\n'
FROM CDs
WHERE Category='Blues' OR Category='Jazz';








Related examples in the same category

1.Backup records into txt file 2
2.Backup file into txt file indicating the line terminator
3.Backup selected records into txt file
4.Add line separator to the backup file
5.Dump record into txt file