NOMINASI MAMA 2013

Kabar kembira bagi pencinta KPop, salah satu ajang penghargaan musik bergengsi yang biasa digelar akhir tahun MAMA (Mnet Asian Music Awards) siap kembali digelar pada 22 November 2013. Selain itu Mnet juga merilis siapa saja nama-nama nominasi dari berbagai kategori pada penghargaan yang kembali akan diselenggarakan di Hongkong.
Berikut kategori serta nominasi pada acara MAMA 2013


Best Male Group:
EXO
SHINee
SHINHWA
Infinite
Teen Top

Best Female Group:
2ne1
SNSD
SISTAR
f(x)
4Minute

Best Music Video: 
G-Dragon
Busker Busker
PSY
Lee Seungchul
Cho Youngpil

Best OST: 
Davichi
The One
Suzy
Yoo Mirae
Jang Yup

Best Female Artist:
Baek Ji Young
Sunmi
Ailee
Lee Hyori
IU

Best Band: 
CNBLUE
Niel
Dick Punks
Busker Busker
Jaurim

Best Rap Performance: 
MFBTY
Geeks
Dynamic Duo
Baechigi
Verbal Jint

Best Male Dance Performance:
B1a4
EXO
Beast
SHINee
Infinite

Best Female Dance Performance:
Girls’ Day
SNSD
Sistar
Crayon Pop
4Minute

Best Male Solo Dance Performance:
G-Dragon
Jay Park
Seungri
Psy
Yang Yoseob

Best Female Solo Dance Performance:
GNa
Seo In Young
Sunmi
CL
Lee Hyori

Best Female Vocal Performance:
Davichi
Lyn
IU
Ailee
Lee Hi

Best Male Vocal Performance:
2AM
Lee Seunggi
Lee Seung Chul
Cho Young Pil
K.Will

New Female Artist:
Lim Kim
Ladies Code
Seungeun
Lee Hi
Crayon Pop

New Male Artist:
Roy Kim
Bum Key
BTS
Yoo Seung Ho
Jung Joon-young

Kalian juga bisa ikut berpartisipasi untuk mendukung artis kesayangan kalian melalui website resmi Mnet dan votingnya akan mulai dibuka 24 Oktober 2013. Sudah siap untuk voting KPopers?

LUHAN SMILING SO ADSSFDGF :D

SUPER JUNIOR, EXO LUHAN D.O KAI

Postgresql order By, Where, Between, Like

Tampilkan data produk yang stoknya 10 dan 20

dbkoperasi=# select *from produk where stok in (10,20);

id | kode | nama | stok | min_stok | harga | jenis_produk_id

----+------+------------------+------+----------+---------+-----------------

1 | TV01 | Televisi 21 inch | 20 | 3 | 1200000 |

2 | K001 | Kulkas 2 Pintu | 10 | 2 | 3150000 | 1

7 | TE01 | Teh Kotak | 10 | 20 | 4000 | 4

(3 rows)

Tampilkan data produk yang harganya kurang dari 1jt

tetapi lebih dari 500rb

dbkoperasi=# select *from produk where harga >500000 and harga <1000000;

id | kode | nama | stok | min_stok | harga | jenis_produk_id

----+------+-------------+------+----------+--------+-----------------

3 | K002 | Kulkas Mini | 15 | 3 | 750000 | 1

5 | M002 | Meja Makan | 1 | 3 | 850000 | 2

(2 rows)

Tampilkan data produk yang harus segera ditambah

stoknya

dbkoperasi=# select nama,stok,min_stok from produk where stok < min_stok;

nama | stok | min_stok

------------+------+----------

Meja Makan | 1 | 3

Teh Kotak | 10 | 20

(2 rows)

dbkoperasi=# select nama,alamat,gender from customer where alamat <> 'Jakarta'and gender='P';

nama | alamat | gender

----------------+---------+--------

Rosalie Naurah | Depok | P

Iffa Nisrina | Kebumen | P

Rahmi Maulida | Medan | P

(3 rows)

dbkoperasi=# select nama,tgl_lahir from customer order by tgl_lahir desc;

nama | tgl_lahir

--------------------+------------

Faiz Fikri | 2009-03-13

Rahmi Maulida | 2006-08-10

Alissa Khairunnisa | 2005-11-16

Rosalie Naurah | 2005-03-08

Iffa Nisrina | 2004-08-17

Defghi Muhammad | 2001-06-10

(6 rows)

select *from customer where id in (2,4,6);

id | nama | alamat | telepon | email | tgl_lahir | kartu_diskon_id

----+--------------------+----------+-----------+----------------------+------------+-----------------

2 | Alissa Khairunnisa | Jakarta | 029879887 | alissa.gmail.com | 2005-11-16 | 2

4 | Faiz Fikri | Semarang | 03698524 | faiz@hotmail.com | 2009-03-13 | 4

6 | Rahmi Maulida | Medan | 036995544 | rahmi@nurulfikri.com | 2006-08-10 | 2

(3 rows)

dbkoperasi=# select *from customer where alamat in ('Jakarta','Medan');

id | nama | alamat | telepon | email | tgl_lahir | kartu_diskon_id

----+--------------------+---------+-----------+----------------------+------------+-----------------

2 | Alissa Khairunnisa | Jakarta | 029879887 | alissa.gmail.com | 2005-11-16 | 2

6 | Rahmi Maulida | Medan | 036995544 | rahmi@nurulfikri.com | 2006-08-10 | 2

(2 rows)

dbkoperasi=# select *from produk where stok >= 10 and stok <=100;

id | kode | nama | stok | min_stok | harga | jenis_produk_id

----+------+------------------+------+----------+---------+-----------------

1 | TV01 | Televisi 21 inch | 20 | 3 | 1200000 |

2 | K001 | Kulkas 2 Pintu | 10 | 2 | 3150000 | 1

3 | K002 | Kulkas Mini | 15 | 3 | 750000 | 1

6 | MI01 | Mie Instan | 100 | 20 | 1250 | 3

7 | TE01 | Teh Kotak | 10 | 20 | 4000 | 4

(5 rows)

dbkoperasi=# select *from produk where stok between 10 and 100;

id | kode | nama | stok | min_stok | harga | jenis_produk_id

----+------+------------------+------+----------+---------+-----------------

1 | TV01 | Televisi 21 inch | 20 | 3 | 1200000 |

2 | K001 | Kulkas 2 Pintu | 10 | 2 | 3150000 | 1

3 | K002 | Kulkas Mini | 15 | 3 | 750000 | 1

6 | MI01 | Mie Instan | 100 | 20 | 1250 | 3

7 | TE01 | Teh Kotak | 10 | 20 | 4000 | 4

(5 rows)

dbkoperasi=# select id,nama,tgl_lahir from customer where date_part ('year',tgl_lahir) between 2000 and 2013;

id | nama | tgl_lahir

----+--------------------+------------

1 | Rosalie Naurah | 2005-03-08

2 | Alissa Khairunnisa | 2005-11-16

3 | Defghi Muhammad | 2001-06-10

4 | Faiz Fikri | 2009-03-13

5 | Iffa Nisrina | 2004-08-17

6 | Rahmi Maulida | 2006-08-10

(6 rows)

dbkoperasi=# select id,nama,tgl_lahir from customer where date_part ('year',tgl_lahir) between 2000 and 2005;

id | nama | tgl_lahir

----+--------------------+------------

1 | Rosalie Naurah | 2005-03-08

2 | Alissa Khairunnisa | 2005-11-16

3 | Defghi Muhammad | 2001-06-10

5 | Iffa Nisrina | 2004-08-17

(4 rows)

dbkoperasi=# select id,nama,tgl_lahir from customer where date_part ('year',tgl_lahir) =2005;

id | nama | tgl_lahir

----+--------------------+------------

1 | Rosalie Naurah | 2005-03-08

2 | Alissa Khairunnisa | 2005-11-16

(2 rows)

dbkoperasi=# select id,nama,tgl_lahir from customer where date_part ('month',tgl_lahir) =11;

id | nama | tgl_lahir

----+--------------------+------------

2 | Alissa Khairunnisa | 2005-11-16

(1 row)

dbkoperasi=# select id,nama,tgl_lahir from customer where date_part ('month',tgl_lahir) =10;

id | nama | tgl_lahir

----+------+-----------

(0 rows)

dbkoperasi=# select nama,tgl_lahir,age(current_date,tgl_lahir) from customer order by tgl_lahir desc;

nama | tgl_lahir | age

--------------------+------------+-------------------------

Faiz Fikri | 2009-03-13 | 4 years 6 mons 26 days

Rahmi Maulida | 2006-08-10 | 7 years 1 mon 29 days

Alissa Khairunnisa | 2005-11-16 | 7 years 10 mons 22 days

Rosalie Naurah | 2005-03-08 | 8 years 7 mons

Iffa Nisrina | 2004-08-17 | 9 years 1 mon 22 days

Defghi Muhammad | 2001-06-10 | 12 years 3 mons 28 days

(6 rows)

dbkoperasi=# select id,kode,nama from produk

where kode like 'K%' or kode like 'M%';

id | kode | nama

----+------+----------------

2 | K001 | Kulkas 2 Pintu

3 | K002 | Kulkas Mini

4 | M001 | Sofa Tamu

5 | M002 | Meja Makan

6 | MI01 | Mie Instan

(5 rows)

dbkoperasi=# select id,kode,nama from produk

where nama ilike '%kulkas%';

id | kode | nama

----+------+----------------

2 | K001 | Kulkas 2 Pintu

3 | K002 | Kulkas Mini

(2 rows)

dbkoperasi=# select id,nama from customer

where nama ilike '%SA%';

id | nama

----+--------------------

1 | Rosalie Naurah

2 | Alissa Khairunnisa

(2 rows)

DATABASE POSTGRESQL DISTINCT DAN GROUP BY

distinct => kalo data yang double munculnya cuma satu, seperti jakarta ada dua tapi nanti cuma muncul satu.

dbkoperasi=# select distinct(alamat) as alamat from customer;

alamat

----------

Jakarta

Semarang

Kebumen

Medan

Depok

(5 rows)

group by => menampilkan jumlah grup

dbkoperasi=# select gender, count(id) as jumlah from customer group by gender;

gender | jumlah

--------+--------

L | 2

P | 4

(2 rows)

dbkoperasi=# select alamat, count(id) as jumlah from customer group by alamat; alamat | jumlah

----------+--------

Jakarta | 1

Semarang | 1

Kebumen | 2

Medan | 1

Depok | 1

(5 rows)

dbkoperasi=# select nama, count(id) as jumlah from produk group by nama;

nama | jumlah

------------------+--------

Kulkas Mini | 1

Meja Makan | 1

Teh Kotak | 1

Mie Instan | 1

Sofa Tamu | 1

Televisi 21 inch | 1

Kulkas 2 Pintu | 1

(7 rows)

dbkoperasi=# select 5 +5 as "5+5=";

5+5=

------

10

(1 row)

Syntax Basis Data (Insert,Create,Delete,Update)

Tabel jenis produk

ani@siswa-desktop:~$ sudo su postgres

[sudo] password for ani:

postgres@siswa-desktop:/home/ani$ psql -U postgres dbkoperasi

psql (9.1.9)

Type "help" for help.

dbkoperasi=# CREATE TABLE jenis_produk (

id integer primary key,

nama varchar (20)

);

dbkoperasi=# \d jenis_produk

Table "public.jenis_produk"

Column | Type | Modifiers

--------+-----------------------+-----------

id | integer | not null

nama | character varying(20) |

Indexes:

"jenis_produk_pkey" PRIMARY KEY, btree (id)

dbkoperasi=# INSERT INTO jenis_produk VALUES (1, 'Elektronik');

INSERT 0 1

dbkoperasi=# INSERT INTO jenis_produk VALUES (2, 'Furniture');

INSERT 0 1

dbkoperasi=# INSERT INTO jenis_produk VALUES (3, 'Makanan');

INSERT 0 1

dbkoperasi=# INSERT INTO jenis_produk VALUES (4, 'Minuman');

INSERT 0 1

dbkoperasi=# SELECT *FROM jenis_produk;

id | nama

----+------------

1 | Elektronik

2 | Furniture

3 | Makanan

4 | Minuman

(4 rows)

2. Table Produk

dbkoperasi=# CREATE TABLE produk(

id serial primary key,

kode varchar(10),

nama varchar (45),

stok integer,

min_stok integer,

harga double precision,

jenis_produk_id integer references jenis_produk(id)

);

Table "public.produk"

Column | Type | Modifiers

-----------------+-----------------------+-----------------------------------------------------

id | integer | not null default nextval('produk_id_seq'::regclass)

kode | character varying(10) |

nama | character varying(45) |

stok | integer |

min_stok | integer |

harga | double precision |

jenis_produk_id | integer |

dbkoperasi=# INSERT INTO produk VALUES (1,'TV01','Televisi 21 inch',20,3,1200000,1);

INSERT 0 1

dbkoperasi=# INSERT INTO produk VALUES (2,'K001','Kulkas 2 Pintu',10,2,3150000,1);

INSERT 0 1

dbkoperasi=# INSERT INTO produk VALUES (3,'K002','Kulkas Mini',15,3,750000,1);INSERT 0 1

dbkoperasi=# INSERT INTO produk VALUES (4,'M001','Sofa Tamu',8,1,3600000,2);

INSERT 0 1

dbkoperasi=# INSERT INTO produk VALUES (5,'M002','Meja Makan',1,3,850000,2);

INSERT 0 1

dbkoperasi=# INSERT INTO produk VALUES (6,'MI01','Mie Instan',100,20,1250,3);

INSERT 0 1

dbkoperasi=# INSERT INTO produk VALUES (7,'TE01','Teh Kotak',10,20,4000,4);

INSERT 0 1

dbkoperasi=# SELECT * from produk;

id | kode | nama | stok | min_stok | harga | jenis_produk_id

----+------+------------------+------+----------+---------+-----------------

1 | TV01 | Televisi 21 inch | 20 | 3 | 1200000 |

2 | K001 | Kulkas 2 Pintu | 10 | 2 | 3150000 | 1

3 | K002 | Kulkas Mini | 15 | 3 | 750000 | 1

4 | M001 | Sofa Tamu | 8 | 1 | 3600000 | 2

5 | M002 | Meja Makan | 1 | 3 | 850000 | 2

6 | MI01 | Mie Instan | 100 | 20 | 1250 | 3

7 | TE01 | Teh Kotak | 10 | 20 | 4000 | 4

(7 rows)

** Untuk Merubah Isi Tabel

dbkoperasi=# UPDATE produk SET kode='S001' where id = 4;

UPDATE 1

dbkoperasi=# UPDATE produk SET kode='M001' where id = 5;

UPDATE 1

Tabel Kartu Diskon

dbkoperasi=# CREATE TABLE kartu_diskon (

dbkoperasi(# id serial primary key,

dbkoperasi(# nama varchar (45),

dbkoperasi(# diskon double precision,

dbkoperasi(# iuran double precision

dbkoperasi(# );

dbkoperasi=# INSERT INTO kartu_diskon VALUES (1,'Bronze',0.025,125000,'BZ')

dbkoperasi-# ;

INSERT 0 1

dbkoperasi=# INSERT INTO kartu_diskon VALUES (2,'Silver',0.1,175000,'SL')

;

INSERT 0 1

dbkoperasi=# INSERT INTO kartu_diskon VALUES (3,'Gold',0.2,250000,'GL')

;

INSERT 0 1

dbkoperasi=# INSERT INTO kartu_diskon VALUES (4,'Platinum',0.3,400000,'PL')

;

INSERT 0 1

dbkoperasi=# select *from kartu_diskon;

id | nama | diskon | iuran | kode

----+----------+--------+--------+------

1 | Bronze | 0.025 | 125000 | BZ

2 | Silver | 0.1 | 175000 | SL

3 | Gold | 0.2 | 250000 | GL

4 | Platinum | 0.3 | 400000 | PL

(4 rows)

Tabel Customer

dbkoperasi=# CREATE TABLE customer(

id serial primary key,

nama varchar(45) not null,

alamat varchar (100) not null,

telepon varchar (45),

email varchar (45),

tgl_lahir date,

kartu_diskon_id integer references kartu_diskon(id)

);

dbkoperasi=# INSERT INTO customer VALUES (1,'Rosalie Naurah','Depok','0219546587','rosalie@yahoo.com','2005-03-08',4);

INSERT 0 1

dbkoperasi=# SELECT * from customer;dbkoperasi=# INSERT INTO customer VALUES (2,'Alissa Khairunnisa','Jakarta','029879887','alissa.gmail.com','2005-11-16',2);

INSERT 0 1

dbkoperasi=# INSERT INTO customer VALUES (3,'Defghi Muhammad','Kebumen','0659894','defghi.gmail.com','2001-06-10',2);

INSERT 0 1

dbkoperasi=# SELECT * from customer;dbkoperasi=# INSERT INTO customer VALUES (4,'Faiz Fikri','Semarang','03698524','faiz@hotmail.com','2009-03-13',4);

INSERT 0 1

dbkoperasi=# INSERT INTO customer VALUES (5,'Iffa Nisrina','Kebumen','014899544','iffa@gmail.com','2004-08-17',1);

INSERT 0 1

dbkoperasi=# INSERT INTO customer VALUES (6,'Rahmi Maulida','Medan','036995544','rahmi@nurulfikri.com','2006-08-10',2);

INSERT 0 1

dbkoperasi=# SELECT * from customer; id | nama | alamat | telepon | email | tgl_lahir | kartu_diskon_id

----+--------------------+----------+------------+----------------------+------------+-----------------

1 | Rosalie Naurah | Depok | 0219546587 | rosalie@yahoo.com | 2005-03-08 | 4

2 | Alissa Khairunnisa | Jakarta | 029879887 | alissa.gmail.com | 2005-11-16 | 2

3 | Defghi Muhammad | Kebumen | 0659894 | defghi.gmail.com | 2001-06-10 | 2

4 | Faiz Fikri | Semarang | 03698524 | faiz@hotmail.com | 2009-03-13 | 4

5 | Iffa Nisrina | Kebumen | 014899544 | iffa@gmail.com | 2004-08-17 | 1

6 | Rahmi Maulida | Medan | 036995544 | rahmi@nurulfikri.com | 2006-08-10 | 2

(6 rows)

** menghapus isi tabel

dbkoperasi=# DELETE FROM customer WHERE id =1;

DELETE 1

** Merubah isi tabel

dbkoperasi=# alter table kartu_diskon add column kode varchar (10);

ALTER TABLE

Tabel Pesanan

dbkoperasi=# CREATE TABLE pesanan(

id serial primary key,

nomor varchar(10) not null,

total double precision,

tanggal date,

customer_id integer references customer(id)

);

dbkoperasi=# \d pesanan

Table "public.pesanan"

Column | Type | Modifiers

-------------+-----------------------+------------------------------------------------------

id | integer | not null default nextval('pesanan_id_seq'::regclass)

nomor | character varying(10) | not null

total | double precision |

tanggal | date |

customer_id | integer |

Tabel Pesanan Produk

dbkoperasi=# CREATE TABLE pesanan_produk (

pesanan_id integer references pesanan(id),

produk_id integer references produk(id),

jumlah integer,

harga double precision

);

CREATE TABLE

dbkoperasi=# \d pesanan_produk

Table "public.pesanan_produk"

Column | Type | Modifiers

------------+------------------+-----------

pesanan_id | integer |

produk_id | integer |

jumlah | integer |

harga | double precision |

Tabel Pembayaran

dbkoperasi=# CREATE TABLE pembayaran (

pesanan_id integer references pesanan(id),

jumlah double precision,

ke integer

dbkoperasi(# );

CREATE TABLE

dbkoperasi=# \d pembayaran

Table "public.pembayaran"

Column | Type | Modifiers

------------+------------------+-----------

pesanan_id | integer |

jumlah | double precision |

ke | integer |

dbkoperasi=# select id,nama,kartu_diskon_id from customer;

id | nama | kartu_diskon_id

----+--------------------+-----------------

1 | Rosalie Naurah | 4

2 | Alissa Khairunnisa | 2

3 | Defghi Muhammad | 2

4 | Faiz Fikri | 4

5 | Iffa Nisrina | 1

6 | Rahmi Maulida | 2

(6 rows)

mubank

Udah bulan april nih..
Gk sabar nunggu tayangan MuBank di trans tv,, gk sbar jg nunggu album dream girl shinee chapter 2..
sabar..sabar.. :D