Last active
March 20, 2019 02:15
-
-
Save fahmiegerton/0bc73ac22d886d002852d3fa36b139c8 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE DATABASE db_apotek; | |
USE db_apotek; | |
CREATE TABLE pelanggan ( | |
IdPel VARCHAR(5) NOT NULL PRIMARY KEY, | |
NamaPel VARCHAR(50) NOT NULL, | |
Alamat VARCHAR(100) NOT NULL, | |
JenKel VARCHAR(1) NOT NULL, | |
Umur VARCHAR(3), | |
NoHp VARCHAR(15) | |
); | |
SELECT * FROM pelanggan; | |
SHOW TABLES; | |
INSERT INTO Pelanggan(IdPel, NamaPel, JenKel, Umur, NoHp, Alamat) VALUES | |
('PEL01','Sukimi', 'L', '25', '0812662212', 'Jl. Buntu Belok Kanan'), | |
('PEL02','Upil', 'L', '30', '0877123321', 'Kampung Durian Ambruk'), | |
('PEL03','Adam', 'L', '26', '02854575', 'Jl. jalan di jalan raya'), | |
('PEL04','Adam Kleeman', 'L', '19', '054842185', 'Jl. Kampung Dukun'); | |
SELECT * FROM pelanggan WHERE NamaPel = 'Sukimin'; | |
-- Update nama Sukimi jadi Sukimin | |
UPDATE Pelanggan SET NamaPel = 'Sukimin' WHERE IdPel = 'Pel01'; | |
SELECT * FROM pelanggan WHERE NamaPel = 'Sukimin'; | |
-- Tampilkan record yang berkaitan dengan kata adam di kolom namapel di tabel pelanggan | |
SELECT * FROM pelanggan WHERE namapel LIKE '%adam%'; | |
-- Update umur | |
UPDATE pelanggan SET umur = '20' WHERE IdPel = 'Pel04'; | |
-- Update alamat, umur dan nomor hp untuk record Adam (Pel03) | |
UPDATE pelanggan SET Alamat = 'Jl. Beler', Umur = '22', NoHp = '08142278901' WHERE IdPel = 'Pel03'; | |
SELECT * FROM pelanggan WHERE IdPel = 'pel03'; | |
INSERT INTO Pelanggan(IdPel, NamaPel, JenKel, Umur) VALUES | |
('PEL05','Kael', 'P', '28'); | |
UPDATE pelanggan SET alamat = NULL, nohp = NULL WHERE IdPel = 'Pel05'; | |
SELECT * FROM pelanggan; | |
-- Hapus Pel05 (Kael) | |
DELETE FROM pelanggan WHERE IdPel = 'Pel05'; | |
-- Hapus multiple record | |
DELETE FROM pelanggan WHERE IdPel IN ('Pel05','Pel01'); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment