SQL/MySQL/Backup Load/Save To Text File

Backup records into txt file

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="Country";

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";