[linux-programlama] Re: MySQL'de 2 islemi tek sorguda halletmek

• Previous message: altay ozaygen: "[linux-programlama] pear ve informix vt"
• Next in thread: Yüksel ÖZCAN: "[linux-programlama] Re: MySQL'de 2 islemi tek sorguda halletmek"

Merhaba;
Hemen bir deneme yapiyorum, evet cal=FDsti.
Sizin isinize yararmi bilmem tabi.

update users
set LAST_LOGIN_TIME_STAMP=3D(select
                       LAST_LOGIN_TIME_STAMP-1
                        from users
                       where username=3D'ozgur' )
where username=3D'ozgur2'

Kolay gelsin.

not: oracle da denedim. (ikinci query i sub query saymazsak mysqlde de
calismali)

Ozgur Ugur
Bil.Muh-Istanbul
Infotech

                                                                       =
                                                                       =
      =20
                    Y=FCksel =D6ZCAN =
                                                                       =
          =20
                    <yukselozcan@celiknet.com> To: <l=
inux-programlama@liste.linux.org.tr> =
      =20
                    Sent by: cc: =
                                                                       =
      =20
                    linux-programlama-bounce@liste.li Subject: =
   [linux-programlama] MySQL'de 2 islemi tek sorguda halletmek =
      =20
                    nux.org.tr =
                                                                       =
      =20
                                                                       =
                                                                       =
      =20
                                                                       =
                                                                       =
      =20
                    07.10.2003 14:16 =
                                                                       =
      =20
                    Please respond to =
                                                                       =
      =20
                    linux-programlama =
                                                                       =
      =20
                                                                       =
                                                                       =
      =20
                                                                       =
                                                                       =
      =20

Tekrar merhaba,
Mysqlde insert ve select kelimelerini tek sorguda kullanmak mumkun. aca=
ba
update ve select komutunu da tek bir cumlede kullanmak mumkunmudur.
M=FCmk=FCnse elinde =F6rne=F0i olan varm=FD. =DEimdiden te=FEekk=FCr ed=
erim.

Y=FCksel =D6ZCAN
www.yuksel.tr.cx

=

• Previous message: altay ozaygen: "[linux-programlama] pear ve informix vt"
• Next in thread: Yüksel ÖZCAN: "[linux-programlama] Re: MySQL'de 2 islemi tek sorguda halletmek"