最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
php update数据更新简单实例
时间:2022-06-24 19:02:12 编辑:袖梨 来源:一聚教程网
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.
";
?>
相关文章
- 新月同行启航培养建议汇总 04-28
- 明日之后质量危机任务目标实现方法 04-28
- 逆水寒手游登云令快速获取指南 04-28
- 以闪亮之名天国信使官方捏脸数据id攻略 04-28
- 决胜巅峰克劳德如何优化打法流程 04-28
- 碧蓝航线水星纪念改造皮肤一览攻略 04-28