php mysql 删除语句怎么写_php mysql delete语句

mysql使用delete语句删除数据库中的数据，delete from 表名 where 条件。

$link=mysql_connect("localhost","root","toor");

if(!$link)

{

echo "连接数据库错误 " . mysql_error();

die();

}

mysql_selectdb("mydatabase");

$sql="select * from user";

$result=mysql_query($sql,$link);

while($row=mysql_fetch_array($result))

{

echo $row['username'] . " " . $row['password'] . " " . $row['email'] . "

";

}

$sql="delete user where username='youthflies'";

mysql_query($sql,$link);

mysql_close($link);

?>