|
|
Re: lug-bg: MySQL update
- Subject: Re: lug-bg: MySQL update
- From: Miroslav Nikolov <mkn@xxxxxxxxxxx>
- Date: Fri, 19 Sep 2003 18:17:56 +0300
- Organization: Gabrovo Game Network
- X.operating-system: non-microsoft
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Friday 19 September 2003 15:28, you 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 .
Zdravej
ami primerno mojesh da napravish
update database.table set credit = '(select credit + 5 from database.table
where user_id= 'nekvo_id')' where user_id='syshtoto_id';
ako pravish neshto na nqkoq golqma/ vajna baza po dobre pyrvo procheti manuala
tova go napisah bez da se zamislqm, no mislq che moje da ti sluji kato nasoka.
- --
Regards,
Miroslav Nikolov
Dept. Gabrovo Game Network
GLOBALCOM Ltd.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE/ax4t3hvdMK8+7aoRAl4oAJ9bI91tjj/tCzIt+LwtTq3Xr+1U9gCeIcdA
bozPh20lV3PNifnJ4g+vQGc=
=T8J6
-----END PGP SIGNATURE-----
============================================================================
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
============================================================================
|
|
|