sql update记录更新详细实例
语法:
[ WITH
UPDATE
[ TOP (expression) [ PERCENT ] ]
{ { table_alias |
[
实例 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.
";
?>
已抢66093个
抢已抢34018个
抢已抢18860个
抢