List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:August 9 1999 9:31pm
Subject:Re: incrementing (not auto)
View as plain text  
At 07:23, 19990809, Pedro Sampaio wrote:
>What i want to know is how can i increment the "0" from angola
>every time i have a visit from that country.  How do i increment
>the num_visitas of a specific row?

UPDATE the_table SET num_visitas = num_visitas + 1 WHERE codigo = 'XX'

You probably want to make codigo a PRIMARY KEY for this table, by
the way.

Tim
Thread
incrementing (not auto)Pedro Sampaio9 Aug
  • Re: incrementing (not auto)Thimble Smith9 Aug