Does MySQL have something like x++ or x-- ???

[Reply-Via-Newsgroup]

Folks,

I have a table containing addresses. I have a seperate contacts table that
contains peoples names - This allows me to record more than one persons name
related to a single address.

My address table contains a numeric field/value. It counts the number of
people that are related to a single address. I am wondering if there is a
method that, with a single query/statement to my database, that I can
increment/decrement this numeric value in the address table pending if I
have added/removed an entry from the contacts table.

I know in PHP, C++ and some other programming langauges, there is something
like count++ or count-- I am wondering if MySQL can provide a similar
feature as this, or do I have to read the existing value,
increment/decrement it, then re-write it back to the table?

All help, via the newsgroup, much appreciated,
randell d.

[Aggro]

Reply-Via-Newsgroup wrote:

My address table contains a numeric field/value. It counts the number of
people that are related to a single address. I am wondering if there is a
method that, with a single query/statement to my database, that I can
increment/decrement this numeric value in the address table pending if I
have added/removed an entry from the contacts table.

Perhaps this would do the trick?

# to add
update yourtablename set value = value + 1 where [add conditions here];

# to remove
update yourtablename set value = value - 1 where [add conditions here];

[Aggro]

Reply-Via-Newsgroup wrote:

My address table contains a numeric field/value. It counts the number of
people that are related to a single address. I am wondering if there is a
method that, with a single query/statement to my database, that I can
increment/decrement this numeric value in the address table pending if I
have added/removed an entry from the contacts table.

Perhaps this would do the trick?

# to add
update yourtablename set value = value + 1 where [add conditions here];

# to remove
update yourtablename set value = value - 1 where [add conditions here];

[Reply-Via-Newsgroup]

"Aggro" <sp**********@yahoo.com> wrote in message
news:Xa***************@read3.inet.fi...

Reply-Via-Newsgroup wrote:

My address table contains a numeric field/value. It counts the number of people that are related to a single address. I am wondering if there is a method that, with a single query/statement to my database, that I can
increment/decrement this numeric value in the address table pending if I
have added/removed an entry from the contacts table.

Perhaps this would do the trick?

# to add
update yourtablename set value = value + 1 where [add conditions here];

# to remove
update yourtablename set value = value - 1 where [add conditions here];

Thanks for the suggestion... I'll try it out over the weekend...

Cheers
randell d.

[Reply-Via-Newsgroup]

"Aggro" <sp**********@yahoo.com> wrote in message
news:Xa***************@read3.inet.fi...

Reply-Via-Newsgroup wrote:

My address table contains a numeric field/value. It counts the number of people that are related to a single address. I am wondering if there is a method that, with a single query/statement to my database, that I can
increment/decrement this numeric value in the address table pending if I
have added/removed an entry from the contacts table.

Perhaps this would do the trick?

# to add
update yourtablename set value = value + 1 where [add conditions here];

# to remove
update yourtablename set value = value - 1 where [add conditions here];

Thanks for the suggestion... I'll try it out over the weekend...

Cheers
randell d.