Chotsani MySQL pakugwiritsa ntchito? Chotsani mawu mu database ya MySQL

MySQL kufufuta pa ntchito?MySQL databasekufufuta mawu

Mawu a MySQL DELETE

Mutha kugwiritsa ntchito lamulo la SQL DELETE FROM kuti muchotse zolemba patebulo la database la MySQL.

Mutha mysql> Chitani lamulo kuchokera ku lamulo mwamsanga kapena PHP script.

galamala

Zotsatirazi ndizomwe zimagwirizana ndi mawu a SQL DELETE kuchotsa deta pa tebulo la data la MySQL:

DELETE FROM table_name [WHERE Clause]

• Ngati palibe KULI ndime yomwe yatchulidwa, zolemba zonse patebulo la MySQL zidzachotsedwa.
• Mutha kufotokoza chikhalidwe chilichonse mu ndime ya KUTI
• Mutha kufufuta zolemba zonse nthawi imodzi patebulo limodzi.

The WHERE clause ndiyothandiza kwambiri mukafuna kuchotsa zolemba zomwe zafotokozedwa patebulo la data.

Chotsani deta kuchokera pamzere wolamula

Apa tidzagwiritsa ntchito ndime ya WHERE mu lamulo la SQL DELETE kuchotsa deta yosankhidwa pa tebulo la deta la MySQL chenweiliang_tbl.

Chitsanzo

Chitsanzo chotsatirachi chichotsa mbiriyo ndi chenweiliang_id 3 pa tebulo la chenweiliang_tbl:

Chotsani deta pogwiritsa ntchito PHP script

PHP imagwiritsa ntchito mysqli_query() kugwira ntchito za SQL.Mutha kugwiritsa ntchito mawu akuti WHERE ndi kapena popanda lamulo la SQL DELETE.

Ntchitoyi imagwira ntchito ndi mysql> Zotsatira za lamulo lochita lamulo la SQL ndizofanana.

Chitsanzo

Chitsanzo chotsatira cha PHP chichotsa mbiriyo ndi chenweiliang_id 3 pa tebulo la 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);
?>