Only copy records : Copy Table « Table Index « SQL / MySQL

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

Only copy records

  
Drop table CDs;
Drop table CDs2;

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');



  
CREATE TABLE CDs2
(
   CDID SMALLINT NOT NULL PRIMARY KEY,
   CDName VARCHAR(5) NOT NULL,
   InStock SMALLINT UNSIGNED NOT NULL
)
SELECT CDID, CDName, InStock
FROM CDs
WHERE Category='Blues' OR Category='Jazz';

select * from CDs2;
select * from CDs;

           
         
    
  

Related examples in the same category