Rubby blog

Wednesday 10 April 2013

CONTOH DATABASE MENGGUNAKAN MY SQL

13:10 rubby blog 1 comment

CONTOH DATABASE PEGAWAI DENGAN MENGGUNAKAN MY SQL

MySQL-Front Dump 2.5

Host: localhost   Database: pw2
--------------------------------------------------------
Server version 5.0.45-community-nt

Table structure for table 'pegawai'

DROP TABLE IF EXISTS `pegawai`;
CREATE TABLE IF NOT EXISTS `pegawai` (
`nip` varchar(10) NOT NULL DEFAULT '' ,
`nama` varchar(30) NOT NULL DEFAULT '' ,
`tgllahir` date NOT NULL DEFAULT '0000-00-00' ,
`jenkel` enum('0','1') NOT NULL DEFAULT '0' ,
`alamat` text NOT NULL DEFAULT '' ,
`namafoto` varchar(50) NOT NULL DEFAULT '' ,
PRIMARY KEY (`nip`),
UNIQUE KEY nim (`nip`),
   KEY nim_2 (`nip`)
);

Dumping data for table 'pegawai'

INSERT INTO `pegawai` (`nip`, `nama`, `tgllahir`, `jenkel`, `alamat`, `namafoto`) VALUES("0111500382", "Abdul Malik", "1970-01-01", "0", "Jakarta Bagian Selatan", "achmatim-mag.jpg");
INSERT INTO `pegawai` (`nip`, `nama`, `tgllahir`, `jenkel`, `alamat`, `namafoto`) VALUES("0411534000", "Budiono", "1986-01-01", "0", "Bandung", "");
INSERT INTO `pegawai` (`nip`, `nama`, `tgllahir`, `jenkel`, `alamat`, `namafoto`) VALUES("5555555555", "sdsf", "1970-01-01", "0", "sfsf", "180px-DSCN0411.JPG");
INSERT INTO `pegawai` (`nip`, `nama`, `tgllahir`, `jenkel`, `alamat`, `namafoto`) VALUES("5222222222", "sds", "1970-01-01", "0", "dsdsd", "02_lan_router.gif");
% mysql Mysql%

   mysql> USE wbluhm ; mysql> USE wbluhm;

   mysql> SELECT * FROM books; mysql> SELECT * FROM buku;

   mysql> SELECT title, price mysql> SELECT judul, harga
       -> FROM books -> FROM buku
       -> ; ->;

   mysql> SELECT title, author mysql> SELECT judul, penulis
       -> FROM books -> FROM buku
       -> WHERE topic="Java"; -> WHERE topik = "Java";

   mysql> SELECT title, author, price mysql> SELECT judul, penulis, harga
       -> FROM books -> FROM buku
       -> WHERE topic="Java" -> WHERE topik = "Java"
       -> ORDER BY price; -> ORDER BY harga;

   mysql> SELECT title, author, price mysql> SELECT judul, penulis, harga
       -> FROM books -> FROM buku
       -> WHERE topic="Java" -> WHERE topik = "Java"
       -> ORDER BY price DESC; -> ORDER BY harga turun;

   mysql> USE samp_db; mysql> USE samp_db;

   mysql> SHOW TABLES; mysql> SHOW TABEL;

   mysql> DESCRIBE president; mysql> Describe presiden;

   mysql> SELECT last_name, first_name, birth mysql> SELECT last_name, FIRST_NAME, kelahiran
       -> FROM president -> DARI presiden
       -> WHERE death IS NULL -> Kematian WHERE IS NULL
       -> ORDER BY last_name; -> ORDER BY last_name;

   mysql> DESCRIBE student; mysql> Describe siswa;

   mysql> DESCRIBE absence; mysql> Describe ketidakhadiran;

   mysql> SELECT student.name, absence.date mysql> SELECT student.name, absence.date
       -> FROM student JOIN absence -> DARI JOIN ketidakhadiran siswa
       -> WHERE student.student_id = absence.student_id; -> WHERE student.student_id = absence.student_id;

   mysql> exit; mysql> exit;

Lagu Religi

14:01 rubby blog No comments

Lagu Religi MP3

Special Religi Jawa
1. Kereto Jowo
2. Ono Sing Takon
3. Sholat Subuh
4. Ayo Ngaji
5. Watu Kayu
6. Ya Rosululloh
7. Sepohon Kayu
8. Zahira - Matahari Dunia

Pop Minang

12:55 rubby blog No comments

Pop Minang

Seleksi Pop Minang Terpopuler
1. Ratok Padi Ampo
2. Rang Si Kumbang
3. Lenya I Nyo Hati
4. Tasisiah
5. Nantido Manahan Hati
6. Lindok Londok
7. Tikuluak Usang
8. Sapayuang Bajauah Hati

RIA AMELIA
1. Pulanglah Uda
2. Cinto Jan Dibali
3. Bareh Solok
4. Kasiah Tak Samapi
5. Hujanlah Turun Pulo
6. Ayam Den Lapeh
7. Ampun Mandeh
8. Hujan
9. Mudiak Mandeh
10. Lintuah
11. Mangkonyo Denai Tagamang
12. Si Nona

NOSTALGIA MINANG PILIHAN
1. Opening
2. Tanti Batanti
3. Ayam Den Lapeh
4. Dindin Badindin
5. Malam Bainai
6. Baralek Gadang
7. Bareh Solok
8. Kampuang Nan Jauah Dimato
9. Kelok 44
10. Lamang Tapai
11. Nan Dinanti
12. Malapeh Hao

Lagu-lagu sunda

15:46 rubby blog No comments

Lagu-lagu sunda
Sundanese Instrumental

Bali Instrumental

Degung instrumental bali 1 - 01. kitagunu no haru.mp3
Degung instrumental bali 1 - 02. sukiyaki.mp3
Degung instrumental bali 1 - 03. kokoro no tomo.mp3

Lagu Hip Hop Indo

15:11 rubby blog No comments

Kumpulan Lagu lagu Hip Hop
mohon maaf baru sedikit upload lagunya,, karena kesibukan,, jadi tidak bisa ngeblog berlama LAMA

Jogjakarta Hip Hop

Saykoji - Andai Aku Bisa
1. Berontak Dalam Sempak

2. Andai Aku Bisa
3. Drama Keadilan
4. I'm Spacer
5. Aku cinta One Blood
6. Senandung Rindu ft Candil
7. My Style Again For Malaysia
8. I Love you Full
9. Hujan Duit
10. Online
11. Kaskus Anthem
12. Merah Putih

BONDAN PRAKOSO & FADE2BLACK - FOR ALL
1. Ya Sudahlah
2. Good Time
3. Tetap Semangat
4. Sang Juara
5. Bumi Ke Langit
6. Not With Me

SHAGGY DOG - KEMBALI BERDANSA
1. Kembali
2. Cobalah Mengerti
3. Bungaku
4. Hey Cantik
5. Special Buat

IWA K
1. Ku Ingin Kembali
2. Batman Kesarung
3. Manusia Malam
4. Bebas
5. Matahariku
6. Terlahir Untukmu
7. Sepenuh Hati
8. Dunia Gila
9. Asal Jangan
10. Tak Terpisahkan