|
|
Re: lug-bg: MySQL update
- Subject: Re: lug-bg: MySQL update
- From: peyo <peyo@xxxxxxxxx>
- Date: Fri, 19 Sep 2003 17:06:54 +0300
On Friday 19 September 2003 15:28, martin petkov wrote:
> 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 |
>
> ----------------
>]
update tablename set credit=credit+5 where user_id>=1 and user_id<=4 and
user_id>=7 and user_id<=8;
> 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
============================================================================
|
|
|