|
|
Re: lug-bg: MySQL update
- Subject: Re: lug-bg: MySQL update
- From: Kamen Tomov <kamen@xxxxxxxxxxx>
- Date: Fri, 19 Sep 2003 16:35:11 +0300
On Fri, Sep 19, 2003 at 05:28:43AM -0700, martin petkov wrote:
> ----------------
> |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 .
UPDATE t1 SET t1.credit=5
WHERE t1.user_id BETWEEN 1 AND 4
OR t1.user_id BETWEEN 7 AND 8
============================================================================
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
============================================================================
|
|
|