MySQL rho tawm ntawm kev siv? rho tawm nqe lus hauv MySQL database

MySQL rho tawm ntawm kev siv?MySQL databaserho tawm nqe lus

MySQL DELETE nqe lus

Koj tuaj yeem siv SQL DELETE FROM cov lus txib kom tshem tawm cov ntaub ntawv hauv MySQL database table.

Koj ua tau mysql> Ua qhov hais kom ua los ntawm kev hais kom ua los yog PHP tsab ntawv.

qauv sau ntawv

Cov hauv qab no yog cov ntsiab lus dav dav ntawm SQL DELETE nqe lus kom rho tawm cov ntaub ntawv los ntawm MySQL cov ntaub ntawv rooj:

DELETE FROM table_name [WHERE Clause]

• Yog tias tsis muaj qhov twg los xij tau teev tseg, tag nrho cov ntaub ntawv hauv MySQL cov lus yuav raug muab tshem tawm.
• Koj tuaj yeem hais qhia txhua yam xwm txheej hauv WHERE clause
• Koj tuaj yeem rho tawm cov ntaub ntawv hauv ib lub rooj tag nrho ib zaug.

Qhov WHERE clause muaj txiaj ntsig zoo thaum koj xav rho tawm cov ntaub ntawv teev tseg hauv cov ntaub ntawv.

Rho tawm cov ntaub ntawv los ntawm kab hais kom ua

Ntawm no peb yuav siv WHERE clause hauv SQL DELETE hais kom tshem tawm cov ntaub ntawv xaiv los ntawm MySQL cov ntaub ntawv rooj chenweiliang_tbl.

piv txwv

Cov piv txwv hauv qab no yuav rho tawm cov ntaub ntawv nrog chenweiliang_id 3 hauv chenweiliang_tbl rooj:

Rho tawm cov ntaub ntawv siv PHP tsab ntawv

PHP siv mysqli_query() muaj nuj nqi los ua SQL nqe lus, thiab koj tuaj yeem siv qhov WHERE clause nrog lossis tsis muaj SQL DELETE hais kom ua.

Cov haujlwm no ua haujlwm nrog mysql> Cov nyhuv ntawm tus cwj pwm hais kom ua tiav cov lus txib SQL yog tib yam.

piv txwv

PHP piv txwv hauv qab no yuav rho tawm cov ntaub ntawv nrog chenweiliang_id 3 hauv chenweiliang_tbl rooj:

<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
 die('连接失败: ' . mysqli_error($conn));
}
// 设置编码，防止中文乱码
mysqli_query($conn , "set names utf8");
 
$sql = 'DELETE FROM chenweiliang_tbl
 WHERE chenweiliang_id=3';
 
mysqli_select_db( $conn, 'chenweiliang' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
 die('无法删除数据: ' . mysqli_error($conn));
}
echo '数据删除成功！';
mysqli_close($conn);
?>