Re: lug-bg: MySQL update

["Vasko Tomanov" <vtomanov@xxxxxxxxxx>]

pointeresuvaj se ot joint neshta

neshto kato:

SELECT * FROM [tabellenname1] T1, [tabellenname2] T2 WHERE T1.id=T2.id

po podoben nasthin se praviat vgradeni select-i na mysql :))

----- Original Message ----- 
From: "martin petkov" <martin_petkov@xxxxxxxxx>
To: <lug-bg@xxxxxxxxxxxxxxxxxx>
Sent: Friday, September 19, 2003 1:28 PM
Subject: lug-bg: MySQL update


> Zdraveite,
> bihte li me posyvetvali za slednata situacia
>
> iskam da update-na opredeleni stoinosti v dadena
> kolona po uslovie ot druga kolona v syshtata tablica
> naprimer
> ----------------
> |user_id|credit|
> ----------------
> |1      |10    |
> |2      |10    |
> |3      |10    |
> |4      |10    |
> |5      |20    |
> |6      |20    |
> |7      |10    |
> |8      |10    |
> ----------------
>
> t.e. kak da se update-nat stoinostite na credit (s 5
> naprimer), koito sa s user_id ot 1-4 i 7-8 .
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
>
============================================================================
> A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
> http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara
Zagora
> To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
>
============================================================================
>

============================================================================
A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
============================================================================