mysql更新数据之update set用法

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1 [, col_name2=expr2 …]
[WHERE where_definition]
[ORDER BY …]
[LIMIT row_count]

create table links (name varchar(255) not null default ”, url varchar(255) not null default ”);

INSERT INTO users(name, age) VALUES(‘姚明’, 25), (‘比尔.盖茨’, 50), (‘火星人’, 600);

update links set url=’http://www.hzhuti.com’;

update user set Password = password(‘123456’) where User = ‘root’;

<?php
$con = mysql_connect(“localhost”,”peter”,”abc123″);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}
mysql_select_db(“my_db”, $con);
mysql_query(“UPDATE Persons SET Age = ’36’
WHERE FirstName = ‘Peter’ AND LastName = ‘Griffin'”);
mysql_close($con);
?>