Kamis, 09 Desember 2010

DATABASE

Contoh database sederhana untuk mengetahui tentang barang,konsumen,distributor dan supermarket !!!

Kita mulai aja...!!!

create database jual_beli; (Namanya terserah sobat !!)

show databases;

use jual_beli;

create table t_barang(id_barang int primary key,nama_barang varchar(100));

(panjang varchar disesuaikan)

create table t_konsumen(id_barang int,id_konsumen int primary key,nama_konsumen varchar(100));

create table t_distributor(id_barang int,id_distributor int primary key,nama_distributor varchar(100));

create table t_supermarket(id_barang int,id_supermarket int primary key,nama_supermarket varchar(100));

show tables;

insert into t_barang()values(1,'A'),(2,'B'),(3,'C'),(4,'D'),(5,'E');

select*from t_barang;

insert into t_konsumen()values(5,1,'Naruto'),(4,2,'Ichigo'),(3,3,'Irie'),(2,4,'Otani'),(1,5,'Onizuka');

select*from t_konsumen;

insert into t_distributor()values(1,1,'AA'),(2,2,'BB'),(3,3,'CC'),(4,4,'DD'),

(5,5,'EE');

select*from t_distributor;

insert into t_supermarket()values(4,1,'1'),(5,2,'2'),(2,3,'3'),

(3,4,'4'),(1,5,'5');

select*from t_supermarket;


Sampai di sini masih ngeti kan????? Oke...kita lanjut lagi !!!!!


Alter table t_barang add harga int;

Update t_barang set harga=100 where id_barang=1;

Update t_barang set harga=100 where id_barang=2;

Update t_barang set harga=100 where id_barang=3;

Update t_barang set harga=100 where id_barang=4;

Update t_barang set harga=100 where id_barang=5;


Select * from t_barang, t_konsumen, t_distributor, t_supermarket where t_

barang.id_barang=t_konsumen.id_barang and t_barang.id_barang=t_distributor.id_ba

rang and t_barang.id_barang=t_supermarket.id_barang;


Selesai!!!!! Semoga membantu.

More information !! Click Here !!!

Tidak ada komentar:

Poskan Komentar