WHERE 條件】。
DELETE FROM 語句用于從數(shù)據(jù)庫表中刪除記錄。
(推薦教程:php圖文教程)
語法:
DELETE FROM table_name WHERE some_column = some_value
Persons表:
(學習視頻推薦:php視頻教程)
代碼實現(xiàn):
<?php
$con=mysqli_connect("localhost","username","password","database");// 檢測連接
if (mysqli_connect_errno()){
echo "連接失敗: " . mysqli_connect_error();
}
mysqli_query($con,"DELETE FROM Persons WHERE LastName='Griffin'");
mysqli_close($con);
?>
刪除后的表:
更多關(guān)于云服務器,域名注冊,虛擬主機的問題,請訪問西部數(shù)碼官網(wǎng):m.ps-sw.cn