Selasa, 29 Mei 2012

MY SQL its so simple

Nama : Fani N
Nim    : 12114038

iseng-iseng belajar MY SQL



> CREATE DATABASE penjualan;
> USE penjualan;
> CREATE TABLE barang (kode_brg char(5) primary key,nama_brg char(30),jenis char(15),jumlah int,harga int);
> INSERT INTO barang values ("F001","intel p i3","prosesor",2,500000);
> INSERT INTO barang values ("F002","samsung 700x","prosesor",3,600000);
> INSERT INTO barang values ("F003","advan G4D","hard disk",5,700000);
> INSERT INTO barang values ("F004","asus DV775","motherboard",4,600000);
> INSERT INTO barang values ("F005","acer 82T","motherboard",5,700000);


> select*from barang;

Tidak ada komentar:

Posting Komentar