casenya,, update Tbl_A set fieldA=null where fieldA='kosong' update Tbl_A set fieldB=null where fieldB='kosong'
gmn tuh,, :) Pada 30 Oktober 2012 15:25, Tedi Kahfi <[email protected]> menulis: > 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
