Praktikum 2

LAPORAN PRAKTIKUM 2

create database supermarket

use supermarket

create table barang(

                kdbrg char(5),

                namabrg varchar(30),

                jenis varchar(15),

                kemasan varchar (20),

                isi varchar(15),

                harga money,

                stok int)

select*from barang

insert into barang values('B0001','SUPER PEL','PEMBERSIHLANTAI','PLASTIK','80ml',10.000,8)

SELECT*FROM barang

insert into barang values('B0002','OBH NELCO','OBAT','BOTOL','85ml',15.000,7)

select*from barang

insert into barang values('B0003','RINSO','DETERGEN','PLASTIK','1Kg',12.000,10)

select*from barang

update barang set namabrg='Daia'where kdbrg='B0003'

select*from barang

delete barang

delete from barang where kdbrg='B0003'

select*from barang