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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 ============================================================================