MySQL replace command : Replace « Function « SQL / MySQL






MySQL replace command

 

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



CREATE TABLE CDs2a
(
   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';

  
REPLACE INTO CDs2
SELECT CDID, CDName, InStock
FROM CDs
WHERE Category='Country' OR Category='Rock';


select * from CDs2;
           
         
  








Related examples in the same category

1.Call REPLACE function in select clause
2.Call concat and replace
3.Do calculation in select clause
4.Replace into
5.Replace more than one column
6.Use the REPLACE command to remove the underscores and insert spaces in their place.