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


SQL / MySQL » Table Index » Backup Table »

 

Backup file indicating line and record separator



Drop table CDs;

CREATE TABLE CDs (
   CDID SMALLINT NOT NULL PRIMARY KEY,
   CDName VARCHAR(50NOT 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';



           
       



Leave a Comment / Note


 
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

SQL / MySQL

 Navioo Table Index
» Backup Table