MySQL hlakola ts'ebelisong? hlakola polelo ho database ea MySQL

MySQL hlakola ts'ebelisong?MySQL databasehlakola polelo

Polelo ea MySQL DELETE

U ka sebelisa taelo ea SQL DELETE FROM ho hlakola litlaleho tafoleng ea database ea MySQL.

u ka khona mysql> Phetha taelo ho tsoa ho taelo ea taelo kapa sengoloa sa PHP.

sebōpeho-puo

Se latelang ke syntax e akaretsang ea polelo ea SQL DELETE ho hlakola data ho tsoa tafoleng ea data ea MySQL:

DELETE FROM table_name [WHERE Clause]

• Haeba ho se na poleloana ea WHERE e boletsoeng, lirekoto tsohle tse tafoleng ea MySQL li tla hlakoloa.
• O ka hlakisa boemo bofe kapa bofe ho poleloana ea WHERE
• U ka hlakola lirekoto kaofela ka nako e le 'ngoe tafoleng e le' ngoe.

Temana ea WHERE e thusa haholo ha o batla ho hlakola lirekoto tse boletsoeng tafoleng ea data.

Hlakola data moleng oa taelo

Mona re tla sebelisa poleloana ea WHERE ho taelo ea SQL DELETE ho hlakola data e khethiloeng ho tafole ea data ea MySQL chenweiliang_tbl.

Mohlala

Mohlala o latelang o tla hlakola rekoto e nang le chenweiliang_id 3 tafoleng ea chenweiliang_tbl:

Hlakola data ka PHP script

PHP e sebelisa mosebetsi oa mysqli_query() ho phethahatsa lipolelo tsa SQL U ka sebelisa poleloana ea WHERE ka kapa ntle le taelo ea SQL DELETE.

Ts'ebetso ena e sebetsa le mysql> Phello ea sebopeho sa taelo ea ho phethahatsa taelo ea SQL e tšoana.

Mohlala

Mohlala o latelang oa PHP o tla hlakola rekoto ka chenweiliang_id 3 tafoleng ea 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);
?>