MySQL tape mai le fa'aoga? tape faʻamatalaga i MySQL database

MySQL tape mai le fa'aoga?MySQL databasetape le faamatalaga

MySQL DELETE faʻamatalaga

E mafai ona e fa'aogaina le fa'atonuga SQL DELETE FROM e tape fa'amaumauga i totonu ole laulau fa'amaumauga MySQL.

E te mafaia MySQL> Faʻatino le faʻatonuga mai se faʻatonuga poʻo se PHP script.

kalama

O loʻo taua i lalo le faʻasologa lautele o le SQL DELETE faʻamatalaga e tape ai faʻamatalaga mai se laulau faʻamaumauga MySQL:

DELETE FROM table_name [WHERE Clause]

• Afai e leai se fuaiupu WHERE o loʻo faʻamaonia, o faʻamaumauga uma i le laulau MySQL o le a tapeina.
• E mafai ona e faʻamaonia soʻo se tulaga i le WHERE fuaiupu
• E mafai ona e tape uma fa'amaumauga i le laulau e tasi.

Ole fuaiupu WHERE e aoga tele pe a e manaʻo e tape faʻamaumauga faʻamaonia ile laulau faʻamaumauga.

Aveese faʻamatalaga mai le laina faʻatonu

O iinei o le a matou faʻaogaina ai le WHERE fuaiupu i le SQL DELETE poloaiga e tape ai faʻamaumauga filifilia mai le MySQL data table chenweiliang_tbl.

Fa'ata'ita'iga

Ole fa'ata'ita'iga lea ole a tapeina fa'amaumauga ile chenweiliang_id 3 ile laulau chenweiliang_tbl:

Aveese faʻamatalaga e faʻaaoga ai le PHP script

PHP faʻaaoga le mysqli_query () galuega e faʻatino ai faʻamatalaga SQL, ma e mafai ona e faʻaogaina le WHERE fuaiupu ma pe leai foi le SQL DELETE poloaiga.

E galue lenei galuega ma MySQL> O le a'afiaga o le amio fa'atonu e fa'atinoina le fa'atonuga SQL e tutusa.

Fa'ata'ita'iga

O le faʻataʻitaʻiga PHP o loʻo mulimuli mai o le a tapeina le faʻamaumauga ma chenweiliang_id 3 i le laulau 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);
?>