MySQL paarẹ lati lilo? pa gbólóhùn rẹ ni MySQL database

MySQL paarẹ lati lilo?MySQL databasepa gbólóhùn

MySQL DELETE gbólóhùn

O le lo SQL DELETE LATI aṣẹ lati pa awọn igbasilẹ rẹ ni tabili data MySQL kan.

o le MySQL> Ṣiṣe aṣẹ naa lati inu aṣẹ aṣẹ tabi iwe afọwọkọ PHP kan.

girama

Atẹle ni sintasi gbogbogbo ti alaye SQL DELETE lati pa data rẹ lati inu tabili data MySQL kan:

DELETE FROM table_name [WHERE Clause]

• Ti ko ba si NIBI ti o ti sọ asọye, gbogbo awọn igbasilẹ ti o wa ninu tabili MySQL yoo paarẹ.
• O le pato ipo eyikeyi ninu gbolohun ọrọ NIBI
• O le pa awọn igbasilẹ rẹ ni ẹẹkan ni tabili kan.

Awọn gbolohun WHERE wulo pupọ nigbati o fẹ pa awọn igbasilẹ pato rẹ ninu tabili data.

Pa data rẹ lati laini aṣẹ

Nibi a yoo lo gbolohun WHERE ninu aṣẹ SQL DELETE lati pa data ti o yan lati inu tabili data MySQL chenweiliang_tbl.

Apeere

Apẹẹrẹ atẹle yoo paarẹ igbasilẹ pẹlu chenweiliang_id 3 ninu tabili chenweiliang_tbl:

Pa data rẹ nipa lilo iwe afọwọkọ PHP

PHP nlo iṣẹ mysqli_query() lati ṣe awọn alaye SQL O le lo gbolohun WHERE pẹlu tabi laisi pipaṣẹ SQL DELETE.

Iṣẹ yii ṣiṣẹ pẹlu MySQL> Ipa ti ohun kikọ aṣẹ ti n ṣiṣẹ pipaṣẹ SQL jẹ kanna.

Apeere

Apẹẹrẹ PHP ti o tẹle yoo pa igbasilẹ rẹ rẹ pẹlu chenweiliang_id 3 ninu tabili chenweiliang_tbl:

<?
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);
?>