欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识！
您现在的位置是： 首页  >  后端开发

php update数据更新简单实例_PHP教程

程序员文章站 2023-12-23 18:46:09
...
sql update记录更新详细实例

语法:

[ WITH [...n] ]
UPDATE
[ TOP (expression) [ PERCENT ] ]
{ { table_alias | | rowset_function_limited
[ WITH ( [ ...n ] ) ]
}
| @table_variable
}
SET
{ column_name= { expression | DEFAULT | NULL }
| { udt_column_name.{ { property_name= expression
| field_name=expression }
| method_name(argument [ ,...n ] )
}
}
| column_name { .WRITE (expression,@Offset,@Length) }
| @variable=expression
| @variable= column=expression
| column_name { += | -= | *= | /= | %= | &= | ^= | |= } expression
| @variable { += | -= | *= | /= | %= | &= | ^= | |= } expression
| @variable=column { += | -= | *= | /= | %= | &= | ^= | |= } expression
} [ ,...n ]

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

::=
{
[ server_name . database_name . schema_name .
| database_name .[ schema_name ] .
| schema_name .
]
table_or_view_name}

实例 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.

";

?>

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/630745.htmlTechArticlesql update记录更新详细实例 语法: [ WITH common_table_expression [...n] ] UPDATE [ TOP (expression) [ PERCENT ] ] { { table_alias | object | rowset_function_limited [ WITH...
相关标签： php update 数据 更新 简单 实例 sql update 记录 更新 详细 实例 语法 WITH common

上一篇：

下一篇：

推荐阅读