coba pake perintah
"UPDATE namatabel SET tgl_masuk='2007-08-19' WHERE nama='aa'";
itu contoh untuk yang nama aa sedangkan namatabel diatas diganti nama
tabel dari query tersebut.
selamat mencoba..
Kang Toha wrote:
>
> hi ITers...
>
> Saya punya data dalam mysql sbb:
>
> nama kota tgl_masuk
> ----------------------------------------------
> aa jakarta 2007-07-19
> bb bandung 2007-07-18
> cc jakarta 2007-07-20
> dd surabaya 2007-08-10
> dst ...
>
> saya ingin update semua bulan 07 ke bulan 08 sementara tahun dan
> tanggalnya
> tetap seperti semula, ada yang bisa bantu gak bagaimana script sqlnya
> untuk
> kasus ini.
>
> Atas bantuan rekan2 IT, saya ucapkan terimakasih.
>
> --
> Regards
>
> Toha
> ----------------------------------------------------------
> "Live your life with love"
>
> [Non-text portions of this message have been removed]
>
>
[Non-text portions of this message have been removed]
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
