php无刷下更新数据,phpupdate数据更新简单实例_PHP教程

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教程

$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.";

?>

http://www.bkjia.com/PHPjc/630745.htmlwww.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中文网