Reply to Re: Increaseing a value

Your name:

Reply:


Posted by Simon on 06/17/05 15:35

> Hello,
>
> I have a table with "score" field.
> In some case, tho Scroe must be increased, normaly I would do this by
> first reading the current score, increasing it in the code then updateing
> it back to the filed, but I was wondering if there was an better way, to
> avoid extra queryes, like some function in the update commad jost to
> increase the current value for some amount without reading it first?
>
> I hope you understand what I mean :)
>
> Thank you in advance.

UPDATE mytable SET myfield = myfield+1 where (somevalue = someothervalue );

Simon.

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация