Database Penjualan

1.       create database jualan;

     

     2.       use jualan;

     3.       create table suplier (kodesuplier integer primary key,namasuplier char(20) not null,alamat char(30)not null default 'Jl. Gejayan No.1',telpon char(15));

create table pelanggan (kodesuplier integer primary key,namasuplier char(20) not null,alamat char(30)not null default 'Jl. Gejayan No.1',telpon char(15));

     4.       create index suplier_my on suplier(namasuplier);

     5.       alter table suplier add kota char(15) after alamat;

alter table suplier drop kota;

     6.       alter table suplier change telepon phone char(15);

     7.       alter table suplier rename to supliyer;

     8.       drop table pelanggan;

     9.       insert into supliyer (namasuplier,kodesuplier,alamat,kota,phone)

      values('Fikri',307,'Jl.Yiik 5','Soerockbojo','0841297461');

      insert into supliyer (namasuplier,kodesuplier,alamat,kota,phone)

      values('Arfiansa',308,'Jl.Yiik 7','Soerockbojo','0841877461');

      insert into supliyer (namasuplier,kodesuplier,alamat,kota,phone)

      values('January',309,'Jl.Yiik 9','Soerockbojo','0841297131');

      insert into supliyer (namasuplier,kodesuplier,alamat,kota,phone)

      values('Faishal',310,'Jl.Yiik 1','Soerockbojo','0849897131');

      insert into supliyer (namasuplier,kodesuplier,alamat,kota,phone)

      values('Nivada',311,'Jl.Yiik 3','Soerockbojo','0841297167');

     10.   update supliyer set namasuplier='Hullatul Jannah',kodesuplier='212',alamat='Jl.Ahmad Yani 31',kota='surabaya',phone='08520241034'

where namasuplier='Nivada';

     11.   delete from supliyer where namasuplier='Faishal';