Dump record into txt file : Backup Table « Table Index « SQL / MySQL

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

Dump record 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 DUMPFILE 'CDsOut.txt'
FROM CDs
WHERE CDID=110;

           
       

Related examples in the same category