php update数据更新简单实例

sql update记录更新详细实例

语法:

[ WITH [...n] ]
UPDATE
[ TOP (expression) [ PERCENT ] ]
{ { table_alias |

[

]
[ FROM { } [ ,...n ] ]
[ WHERE {
| { [ CURRENT OF
{ { [ GLOBAL ] cursor_name }
| cursor_variable_name
}
]
}
}
]
[ OPTION ( [ ,...n ] ) ]
[ ; ]

实例 php教程

mysql教程_connect("mysql153.secureserver.net","java2s","password");
mysql_select_db("java2s");

$query = "UPDATE Employee SET salary = '39.99' ";
$result = mysql_query($query);
echo "There were ".mysql_affected_rows()." product(s) affected. ";

?>

利用update 更新数据

mysql_connect("mysql153.secureserver.net","java2s","password");
mysql_select_db("java2s");

$rowID = "0001";
$name = "Kate";
$price = "12";

$query = "UPDATE Employee SET name='$name', price='$price' WHERE ID='$rowID'";
$result = mysql_query($query);

if ($result)
echo "

The developer has been successfully updated.

";
else
echo "

There was a problem updating the developer.

";

?>