萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 資料庫 >> MySQL 教學

MySQL DELETE 刪除單筆資料:基礎語法與 PHP 實作範例

基本 DELETE 語法

DELETE FROM table_name
WHERE column_name = some_value;
  • WHERE 子句指定刪除條件,省略將清空整張表
  • SQL 不區分大小寫,DELETE FROM 與 delete from 等效

指令列範例

mysql> DELETE FROM users WHERE id = 1;
Query OK, 1 row affected (0.01 sec)

PHP 串接範例 (mysqli 推薦)

注意:舊版 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 驗證條件
  • 大量刪除考慮分批次,避免長鎖表
copyright © 萬盛學電腦網 all rights reserved