Gunakan store procedure aja biar lebih fleksibel untuk codingnya
________________________________
Dari: Tedi Kahfi <[email protected]>
Kepada: [email protected]
Dikirim: Selasa, 30 Oktober 2012 15:40
Judul: Re: [Mugi] Bls: if di syntax mysql
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
_______________________________________________
Mugi mailing list
[email protected]
http://lists.mugi.org/mailman/listinfo/mugi
