I-BEGO

Indonesian Best Generation

Skip to content

[ask] penggunaan function ISNULL()

Forum diskusi membahas semua mengenai MySQL Server

Moderator: trail

Post a reply

[ask] penggunaan function ISNULL()

Postby noeldejavu » 10 Nov 2011, 09:29

Dear all master,

Bagaimana yach cara menggunakan fungsi isnull() di mysql, kalo di ms sql khans spt ini :

select isnull(field,0) as field from table

Terima kasih
Noel deJavu
noeldejavu
Prajurit Satu
Prajurit Satu
 
Posts: 74
Joined: 26 Oct 2011, 23:35
Memberi kopi: 3 cangkir
Mendapat kopi: 1 cangkir
Top

Re: [ask] penggunaan function ISNULL()

Postby vberror13 » 10 Nov 2011, 13:51

Kalo persamaan MS SQL ISNULL, di Mysql namanya IFNULL(exp1, exp2). Penggunaan isnull di mysql, mungkin bisa baca manualnya.
:ymbilly: :ymbilly: :ymbilly: =:) :ymbilly:
Just Because You Are Unique, Doesn't Mean You Are Useful
User avatar
vberror13
Global Moderator
Global Moderator
 
Posts: 1847
Joined: 13 Mar 2010, 20:34
Location: Medan Indonesia
Memberi kopi: 296 cangkir
Mendapat kopi: 321 cangkir
Top

Re: [ask] penggunaan function ISNULL()

Postby novaedp » 10 Nov 2011, 15:36

lebih lengkap silahkan baca dsni http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html
just wanna code something and share it.
novaedp
Prajurit Kepala
Prajurit Kepala
 
Posts: 468
Joined: 26 Mar 2010, 18:56
Memberi kopi: 8 cangkir
Mendapat kopi: 58 cangkir
Top

Re: [ask] penggunaan function ISNULL()

Postby vbgila » 29 Nov 2011, 10:08

Code: Select all
SELECT IF (ISNULL(field),'0',field) as field FROM table
Salam SuperImage
User avatar
vbgila
Prajurit Kepala
Prajurit Kepala
 
Posts: 339
Joined: 27 Jun 2011, 13:24
Location: Dunia Fana
Memberi kopi: 37 cangkir
Mendapat kopi: 56 cangkir
Top
Post a reply

Return to MySQL

Who is online

Users browsing this forum: No registered users and 1 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

-- SEO --