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.
";
?>
http://www.bkjia.com/PHPjc/630745.html www.bkjia.com true http://www.bkjia.com/PHPjc/630745.html TechArticle sql update记录更新详细实例 语法: [ WITH common_table_expression [...n] ] UPDATE [ TOP (expression) [ PERCENT ] ] { { table_alias | object | rowset_function_limited [ WITH...
Statement: The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn