Monday, January 11, 2010

start type a blog again... english story.

i started write again to get a way my unmood mind that make me lazy to do anything. why i wrote this in english? i have story today about how important english in our life. when we tried to forget it, we will always find how important it is as how we need a girl in our life. hehehe. i'm sorry if i wrote it with a lot of gramatical mistake and many other because i were to sleepy. hehehe.
we ussually find english requirement when we look for a job. how we could complish the requirement with the easy way? there are many way to make it done. the positive way with learn english since we were a child or attend for english english class to learn it quick. there are a few people with lazy minded who didn't with something like english for our life. we could find a sertificate with easy way, like scan the sertificate and change the name and score of the sertificate to get a good score and easy way. hahaha. there are many of my friend did that way.
if we remember it again how important english in our life how could a people did like that to get sertificate that tell she/he qualified in english. are they didn't care if they do like that, the god will punish them in hell. hahaha. it's funny story. people who didn't care about life after this world life. hehehe.
learning english is basically easy. when we try to speak everyday with english altought we have a lot of mistake, we will easy to learn from that way because we will find what were wrong from we have tell and we were comfortable in speaking in english. when we didn't have media to learn english, we could try something like :
  • chat with foregn people in social networking
  • listening an english program or movie with no translate
  • reading a book or magazine who were wrote in english
  • play a game or something that smell english
  • etc.
thats all from me tonight. my eyes were to hard to open again and my neck can't hold my head. sorry if i made much mistake. thank you from every one who inspirate me to bloging again. hehehe.

Monday, November 30, 2009

update driver motheroard intel DG411RQ

biasanya klo kita mau instal os ke komputer kita klo pake os versi baru , drivernya ngk update . Jadinya bikin kompi kita ngk maksimal kinerjanya. buat yang make motherboard intel DG41RQ bisa download motherboardnya disini.

Saturday, July 25, 2009

Streaming film asia

Kamu menyukai film korea. Bingung nyari filmnya dimana? mau download tapi ngk punya kapasitas lebih? mau pinjem filmnya ngk ada or lagi bokek?
Ngk usah khawatir klo kayak gitu. Asalkan kita punya internet cepet semua bisa teratasi. hehehe. tinggal siapkan cemilan, soda ato kopi buat menemanimu nonton. bersama pacar lebih asik lagi tuh. hehehe.
nie qu sediain link buat nonton or download film asia. semoga bermafaat dan menghibur. hehehe.

Friday, July 17, 2009

OST - City Of Angels


01. U2 - If God Would Send His Angels
02. Alanis Morissette - Uninvited
03. Jimi Hendrix - Red House
04. Paula Cole - Feelin' Love
05. John Lee Hooker - Mama, You Got A Daughter
06. Sarah Mclachlan - Angel
07. Goo Goo Dolls - Iris
08. Peter Gabriel - I Grieve
09. Jude - I Know
10. Eric Clapton - Further On Up The Road
11. Gabriel Yared - An Angel Falls
12. Gabriel Yared - The Unfeeling Kiss
13. Gabriel Yared - Spreading Wings
14. Gabriel Yared - City Of Angels

link download ost city of angels
http://rapidshare.com/files/91979734/COAs_ST.rar.html

Saturday, July 11, 2009

convert string ke integer dalam mysql

Apakah kita dapat melakukan operasi bilangan dalam database dengan tipe data string? Apakah itu mungkin? Sering kali kita bingung untuk mengubah tipe data yang akan kita tampilakan dari database yang bertipe string ke dalam tipe integer. Hal ini berguna apabila kita memiliki primary key yang bertipe string contohnya nomer kode buku dalam perpustakaan.
Disini kita memiliki data yang isinya merupakan kombinasi angka dan huruf. angka disini menentukan nomer buku dan huruf adalah jenis buku. Kapan saat konversi ini dibutuhkan? konversi ini akan dibutuhkan pada saat kita melakukan penambahan buku. Kita tidak boleh mengisi kode buku yang sama dengan yang lain karena itu akan mengakibatkan kerusakan data. Sebaiknya disini kan pada saat kita akan menambahkan buku maka akan diinputkan secara otomatis kode buku yang kita akan tambahkan. Disini kita tidak bisa melakukan fungsi standar yang ada dalam database seperti auto increment karena tipe data kita adalah string. Bagaimana query sqlnya? begini caranya :

SELECT MAX(CONVERT(nama_colom, tipe_data)) FROM nama_tabel;


keterangan :
max : untuk mengambil nilai maksimum
convert : mengkonversi string ke integer
tipe data : kita dapat mengisi tipe data dengan
  • BINARY[(N)]

  • CHAR[(N)]

  • DATE

  • DATETIME

  • DECIMAL[(M[,D])]

  • SIGNED [INTEGER]

  • TIME

  • UNSIGNED [INTEGER]

contoh sql :

SELECT MAX(CONVERT(kode_buku,signed)) FROM buku WHERE kode_buku like %roman%;

query tersebut bertujuan untuk mencari nilai maksimum dari kode buku yang berjenis roman. Jika anda mau mencari nilai incrementnya silahkan tambahkan +1 setelah max.

Contoh sql :
SELECT MAX(CONVERT(kode_buku,signed))+1 AS kode FROM buku WHERE kode_buku like %roman%;
sql ini akan menghasilkan nilai maksimum ditambah satu / next auto increment.

semoga ini bisa bermanfaat...
hehehe...