Kim Sungra
THIS BLOG CONTAIN MY CAMPUS'S LESON, KPOP, ETC ENJOY :D
Rabu, 23 Oktober 2013
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?
Senin, 21 Oktober 2013
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)
Selasa, 08 Oktober 2013
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)
Senin, 01 April 2013
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
Langganan:
Postingan (Atom)