Trieple-Six: Contoh Membuat Table Mysql

Create table Kasir

( Nopeg char(10) PRIMARY KEY,

Nama varchar(100),

Alamat varchar(100)

);

INSERT INTO kasir VALUES ('K1', 'kasino1', 'aceh');

INSERT INTO kasir VALUES ('K2', 'kasino2', 'sigli');

INSERT INTO kasir VALUES ('K3', 'kasino3', 'bireuen');

INSERT INTO kasir VALUES ('K4', 'kasino4', 'takengon');

INSERT INTO kasir VALUES ('K5', 'kanino5', 'Meulaboh');

INSERT INTO kasir VALUES ('K6', 'kasino6', 'singkil');

INSERT INTO kasir VALUES ('K7', 'kasino7', 'tapaktuan');

INSERT INTO kasir VALUES ('K8', 'kasino8', 'langsa');

INSERT INTO kasir VALUES ('K9', 'kasino9', 'jantho');

INSERT INTO kasir VALUES ('K10', 'kasino10', 'lhokseumawe');

Create table Barang

( Kd_brg char(10) PRIMARY KEY,

Nm_brg varchar(100),

Jenis char(45),

Merek char(45),

Harga float,

);

INSERT INTO barang VALUES ('B1', 'kopi', 'Minuman', 'Uleekareng', '3000');

INSERT INTO barang VALUES ('B2', 'kopi', 'Minuman', 'Uleekareng', '3000');

INSERT INTO barang VALUES ('B3', 'kopi', 'Minuman', 'Uleekareng', '3000');

INSERT INTO barang VALUES ('B4', 'kopi', 'Minuman', 'Uleekareng', '3000');

INSERT INTO barang VALUES ('B5', 'kopi', 'Minuman', 'Uleekareng', '3000');

INSERT INTO barang VALUES ('B6', 'kopi', 'Minuman', 'Uleekareng', '3000');

INSERT INTO barang VALUES ('B7', 'kopi', 'Minuman', 'Uleekareng', '3000');

INSERT INTO barang VALUES ('B8', 'kopi', 'Minuman', 'Uleekareng', '3000');

INSERT INTO barang VALUES ('B9', 'kopi', 'Minuman', 'Uleekareng', '3000');

INSERT INTO barang VALUES ('B10', 'kopi', 'Minuman', 'Uleekareng', '3000');

select Nopeg, Nama, Kd_brg, Nm_Brg, Harga, No_Kwi, Harga * jml_brg as Ttl_byr, Jml_brg, Harga * jml_brg as TotJual from barang, jual, kasir where barang.kd_brg=jual.kdbrg and kasir.nopeg=jual.no_peg;

select Nopeg, Nama, Kd_brg, Nm_Brg, Harga, No_Kwi, Harga * jml_brg as Ttl_byr, Jml_brg, Harga * jml_brg as TotJual from barang, jual, kasir where barang.kd_brg=jual.kdbrg and kasir.nopeg=jual.no_peg and No_Kwi between 'F-00000001' and 'F-00000001';

Trieple-Six

Serch

Translate

Label

Follower

Entri Populer

Contoh Membuat Table Mysql

0 comments:

Posting Komentar