Jump to content

Archived

This topic is now archived and is closed to further replies.

alexville

Adding 1 to a number in a database

Recommended Posts

Hello,

I am making a php script. And I need help. I want to run a query where it grabs a number from the database then adds 1 to it. Could someone run me though this?

Share this post


Link to post
Share on other sites
For incrementing and updating the row:
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']UPDATE[/span] table_name SET column_name [color=orange]=[/color] column_name [color=orange]+[/color] 1 [color=green]WHERE[/color] some_column [color=orange]=[/color] [color=red]'something'[/color]
[!--sql2--][/div][!--sql3--]

For just selecting data and incrementing that value without updating existing row:
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] column_name [color=orange]+[/color] 1 [color=green]AS[/color] incremented_value [color=green]FROM[/color] [color=orange]table_name[/color] [color=green]WHERE[/color] some_column [color=orange]=[/color] [color=red]'something'[/color]
[!--sql2--][/div][!--sql3--]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.