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

18 votes158 views2 answers
Sql comments
SQL
1 vote137 views1 answer
How to check the mysql version mac
SQL
2 votes155 views2 answers
Convert_tz mysql
SQL
2 votes121 views2 answers
How to get capital letter first in sql
SQL
13 votes127 views6 answers
Restart postgresql
SQL
0 vote159 views1 answer
Wordpress sql find and replace
SQL
7 votes112 views1 answer
Safe mode mysql
SQL
0 vote149 views1 answer
Sql set data from a select query to a temp table and insert
SQL
0 vote141 views1 answer
How to join result table in mysql
SQL
0 vote143 views1 answer
Compare if is null sql
SQL