Belajar cara menambah tabel, mengisi, hapus, dan rubah

Praktek Pemrograman SQL

Selasa, 21 Maret 2017

create database "3076"
use "3076"

create table Supplier(
kdsup varchar(10) primary key,
nmsup varchar(50),
tgllhr date,
alamatkantor varchar(50),
telpkantor varchar(15),
jekel varchar(15),
email varchar(20))

select * from Supplier

insert into Supplier
values ('Sup001',' Firman Ilahudin','12/04/1980','Jl. Gondang Manis','0291-5546738','Pria','Firman001@gmail.com')

insert into Supplier
values('Sup002','Joko Waluyo','07/03/1979','Jl. Bumi Wonosari','024-889772','Pria','Jwal@gmail.com')

insert into Supplier
values('Sup003','Ilham Wahid','1982/08/19','Jl. Dersalam','0291-889324','Pria','Wahid@gmail.com')

insert into Supplier
values ('Sup004','Agus waluyo','1998/08/08','Jl. Mayong Jepara','0291-002123','Pria','Waluyo@gmail.com')

insert into Supplier
values ('Sup005','Rofiyatun','1997/06/11','Jl. Rahtawu Kudus','0921-876954','Wanita','Uci@gmail.com')

insert into Supplier
values ('Sup006','Anjelina','1996/05/02','Jl. Karayanganyar Demak','0291-234133','Wanita','Anjel@gmail.com')

insert into Supplier
values ('Sup007','Fahrul Annas','1997/07/12','Jl. Puncakwangi Pati','0291-999543','Pria','Fahrul@gmail.com')

insert into Supplier
values ('Sup008','Sovia','1997/04/21','Jl. Sukolilo Pati','0291-085432','Wanita','Nyopik@gmail.com')

insert into Supplier
values ('Sup009','Anin Dita','1998/04/02','Jl. Nalumsari Jepara','0291-113638','Wanita','Dita@gmail.com')

insert into Supplier
values ('Sup010','Nisrina','1997/04/02','Jl. Agil Kusumadya Kudus','0291-012521','Wanita','Nisrina@gmail.co')

select * from supplier

create table BARANG
(kdbrg varchar (10) primary key,
nmbrg varchar (50),
jnsbrg varchar (20),
harga int,
jumlah int,
)

11. edit table barang, tambahkan satu field tanggal kadaluarsa