Mysql add to value

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

mysql_query("UPDATE `some_table` SET `value` = `value` + 1000 WHERE `id` = 1");

mysql_close($con);
?>

Similar codes

4 votes1.1K views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote170 views1 answer
How many columns can be used for creating index?
SQL
0 vote179 views1 answer
Logtash mysql cofiguration file
SQL
36 votes178 views3 answers
Finding duplicate column values in table with sql
SQL
1 vote163 views1 answer
How to get mysql db size
SQL
0 vote177 views1 answer
New rails app with mysql
SQL
5 votes180 views1 answer
Sort order on two columns sql
SQL
3 votes166 views2 answers
Postgresql remove not null constraint
SQL
1 vote185 views4 answers
Get week day from date in sql
SQL
1 vote137 views1 answer
Database run
SQL