mysql delete 删除一条记录简单办法[网站美工]

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

mysql_query("delete from person where lastname='griffin'");

mysql_close($con);
?>

下面看一下关于mysql delete语法.

删除数据库中的数据
delete from 语句用于从数据库表中删除记录.

语法

delete from table_name
where column_name = some_value

注释:sql 对大小写不敏感.delete from 与 delete from 等效.

为了让 php 履行上面的语句,我们必须利用 mysql_query( 函数.该函数用于向 sql 衔接发送查询和号令