itu kan kondisinya satu, klo kondisinya banyak pke or aja ya,, hee Pada 30 Oktober 2012 15:04, Luki Ishwara <[email protected]> menulis:
> 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 > >
_______________________________________________ Mugi mailing list [email protected] http://lists.mugi.org/mailman/listinfo/mugi
