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

sql update记录更新详细实例

语法:

[ WITH [...n] ]
UPDATE
    [ TOP (expression) [ PERCENT ] ]
    { { table_alias |

    [

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

实例 php教程

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

神采PromeAI

将涂鸦和照片转化为插画，将线稿转化为完整的上色稿。

下载

立即学习“PHP免费学习笔记（深入）”；

";
      else
         echo "

There was a problem updating the developer.

";

 

?>