mysql 排序修改删除

排序：

<?php

$con=mysql_connect("localhost","root","");

if(!$con){

die("连接失败".mysql_error);

}

mysql_select_db("school",$con);

//根据Name排序，ORDER BY Name DESC倒序

$result=mysql_query("SELECT * FROM student ORDER BY Name");

while($row=mysql_fetch_array($result)){

echo $row['Name']." ".$row['Sex'];

echo "<br/>";

}

mysql_close($con);

?>

修改：

mysql_query("UPDATE student SET Age='23' WHERE Name='xxx' AND Sex='xxx'");

删除：

mysql_query("DELETE FROM student WHERE Name='xxx'");