DELETE FROM table_name
WHERE column_name = some_value;
WHERE 子句指定刪除條件,省略將清空整張表DELETE FROM 與 delete from 等效mysql> DELETE FROM users WHERE id = 1;
Query OK, 1 row affected (0.01 sec)
注意:舊版 mysql_* 函式已棄用,建議改用 mysqli 或 PDO。
<?php
$mysqli = new mysqli("localhost", "user", "password", "my_db");
if ($mysqli->connect_errno) {
die("連線失敗: " . $mysqli->connect_error);
}
$stmt = $mysqli->prepare("DELETE FROM person WHERE lastname = ?");
$stmt->bind_param("s", $lastname);
$lastname = "Griffin";
$stmt->execute();
echo "刪除筆數: " . $stmt->affected_rows;
$stmt->close();
$mysqli->close();
?>
WHERE 避免誤刪全表SELECT 驗證條件