kan gampangnya : update tabelA set FieldA = 'kosong' where FieldA is null
kenapa mesti pakai if then else. 2012/10/30 Tedi Kahfi <[email protected]> > saya masih bingung pak klo case gini gmn?? > > jika FieldA pada tabelA = null > maka update tabelA set fieldA='kosong' > gmn ya?? > hee > > Pada 30 Oktober 2012 14:48, Tedi Kahfi <[email protected]>menulis: > > dicoba dulu bro,, >> mksih linknya pak,, :) >> >> Pada 30 Oktober 2012 14:31, Atwis AHS <[email protected]> menulis: >> >> select if(a.no_kwitansi_estimasi<>'','True','False') from t_tabel; >>> >>> ------------------------------ >>> *Dari:* Tedi Kahfi <[email protected]> >>> *Kepada:* mugi <[email protected]> >>> *Dikirim:* Selasa, 30 Oktober 2012 14:20 >>> *Judul:* [Mugi] if di syntax mysql >>> >>> bro,, >>> kalo penulisan syntax if dan else di mysql cara penulisannya gmn ya?? >>> bisa ga ya?? >>> saya masih confuse?? :D >>> >>> _______________________________________________ >>> Mugi mailing list >>> [email protected] >>> http://lists.mugi.org/mailman/listinfo/mugi >>> >>> >>> >>> _______________________________________________ >>> Mugi mailing list >>> [email protected] >>> http://lists.mugi.org/mailman/listinfo/mugi >>> >>> >> > > _______________________________________________ > Mugi mailing list > [email protected] > http://lists.mugi.org/mailman/listinfo/mugi > > -- Best Regards, Luki Ishwara "*Di depan memberi teladan, di tengah memberi bimbingan, di belakang memberi dorongan*"
_______________________________________________ Mugi mailing list [email protected] http://lists.mugi.org/mailman/listinfo/mugi
