update tabelA set fieldA='kosong' where fieldA is null;
________________________________
Dari: Tedi Kahfi <[email protected]>
Kepada: [email protected]
Dikirim: Selasa, 30 Oktober 2012 14:55
Judul: Re: [Mugi] Bls: if di syntax mysql
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
_______________________________________________
Mugi mailing list
[email protected]
http://lists.mugi.org/mailman/listinfo/mugi
