Menggunakan Case pada Xampp
- Membuat Table Product
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `nortwind`
--
-- --------------------------------------------------------
--
-- Table structure for table `product`
--
CREATE TABLE IF NOT EXISTS `product` (
`ProductID` int(10)
DEFAULT NULL,
`ProductName`
varchar(60) DEFAULT NULL,
`UnitInStock`
int(10) DEFAULT NULL,
`Keterangan`
varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `product`
--
INSERT INTO `product` (`ProductID`, `ProductName`,
`UnitInStock`, `Keterangan`) VALUES
(1, 'Chai', 39, ''),
(2, 'Chang', 17, ''),
(3, 'Aniseed Syrup', 13, ''),
(4, 'Chef Anton s Cajon Seosoning', 53, ''),
(5, 'Chef Anton s Gumbo Mix', 0, ''),
(6, 'Grandma s Boysenberry Spread', 120, ''),
(7, 'Uncle Bob s Organic Dried Pears', 15, ''),
(8, 'Nortwoods Cranberry Sauce', 6, ''),
(9, 'Mishi Kobe Niku', 29, ''),
(10, 'Ikura', 31, ''),
(11, 'Queso Cabrales', 22, ''),
(12, 'Queso Manchego La Pastora', 86, ''),
(13, 'Konbu', 24, ''),
(14, 'Tofu', 35, ''),
(15, 'Genen Shouyu', 39, '');
#memasukan Case
select ProductID,ProductName,UnitInStock,
case
when UnitInStock >5 then 'Stock Habis'
when UnitInStock between 5 and 15 then 'Harus
Order'
else 'Stock Cukup'
end as Keterangan
from product
- · Membuat table Customer
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `nortwind`
--
-- --------------------------------------------------------
--
-- Table structure for table `customer`
--
CREATE TABLE IF NOT EXISTS `customer` (
`CustomerID`
varchar(30) DEFAULT NULL,
`CompanyName`
varchar(60) DEFAULT NULL,
`Negara` varchar(60)
DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `customer`
--
INSERT INTO `customer` (`CustomerID`, `CompanyName`,
`Negara`) VALUES
('ALFKI', 'ALFREDS FUTTERKISTE', 'GERMANY'),
('ANATR', 'ANA TRUJILLO EMPAREDADOS Y HELADOS', 'MEXICO'),
('ANTON', 'ANTONIO MORENO TAQUERIA', 'MEXICO'),
('AROUT', 'AROUND THE HORN', 'UK'),
('BERGS', 'BERGLUNDS SNABBKOP', 'SWEDEN'),
('BLAUS', 'BLAUER SEE DELIKATESSEN', 'GERMANY'),
('BOTTM', 'BOTTOM-DOLLAR MARKETS', 'CANADA'),
('BSBEV', 'B S BEVERAGES', 'UK'),
('CACTU', 'CACTUS COMIDAS PARA ILEVAR', 'ARGENTINA'),
('DRACD', 'DRACHENBLUT DELIKATESSEN', 'GERMANY'),
('DUMON', 'DU MONDE ENTIER', 'FRANCE'),
('EASTC', 'EASTERN CONNECTION', 'UK'),
('GOURL', 'GOURMET LANCHONETES', 'BRAZIL'),
('GREAL', 'GREAT LAKES FOOD MARKET', 'USA');
#memasukkan Case
select CustomerID,CompanyName,
case
when 'USA' then 'United State of America'
when 'UK' then 'United Kingdoms'
else Negara
end as Country
from customer
