Increasing a number

DSL · 05-08-2004, 06:22 PM

Ok I know I can do this by doing a query and then doing +1 to the current number, but is there any other simpler way instead of having to do all queries?

Like say in my row in my table the count field is 1, and I want to make it 2 by adding a 1 to it, is there a simpler way?

deadserious · 05-08-2004, 06:37 PM

Code:

UPDATE counter SET count = count + 1

Something like that in your query should do it.

DSL · 05-08-2004, 07:18 PM

Thanks!

05-08-2004, 06:22 PM	THREAD STARTER #1 (permalink)
DSL Senior Member Join Date: Jun 2003 Posts: 2,115	Increasing a number Ok I know I can do this by doing a query and then doing +1 to the current number, but is there any other simpler way instead of having to do all queries? Like say in my row in my table the count field is 1, and I want to make it 2 by adding a 1 to it, is there a simpler way?

05-08-2004, 06:37 PM	#2 (permalink)
deadserious Senior Member Join Date: Aug 2002 Posts: 1,255	Code: UPDATE counter SET count = count + 1 Something like that in your query should do it.

05-08-2004, 07:18 PM	THREAD STARTER #3 (permalink)
DSL Senior Member Join Date: Jun 2003 Posts: 2,115	Thanks!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)