Simple example of php update data update_PHP tutorial

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 更新数据

<?php

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