MySQL hichapụ na ojiji? hichapụ nkwupụta na MySQL nchekwa data

MySQL hichapụ na ojiji?MySQL nchekwa datahichapụ nkwupụta

MySQL DELETE nkwupụta

Ị nwere ike iji SQL DELETE FROM iwu ka ihichapụ ndekọ na tebụl nchekwa data MySQL.

ị nwere ike MySQL> Mezue iwu ahụ site na ngwa ngwa ma ọ bụ ederede PHP.

ụtọ asụsụ

Ihe na-esonụ bụ syntax izugbe nke nkwupụta SQL DELETE ka ihichapụ data na tebụl data MySQL:

DELETE FROM table_name [WHERE Clause]

• Ọ bụrụ na enweghị ebe akọwapụtara nkebi ahịrịokwu, a ga-ehichapụ ihe ndekọ niile dị na tebụl MySQL.
• Ị nwere ike ịkọwa ọnọdụ ọ bụla na nkebiokwu WHERE
• Ị nwere ike ihichapụ ndekọ niile n'otu oge n'otu tebụl.

Nkejiokwu WHERE bara ezigbo uru mgbe ịchọrọ ihichapụ ndekọ akọwapụtara na tebụl data.

Hichapụ data site na ahịrị iwu

N'ebe a, anyị ga-eji nkeji okwu WHERE dị na SQL DELETE iwu ka ihichapụ data ahọpụtara na tebụl data MySQL chenweiliang_tbl.

ihe atụ

Ihe atụ na-esonụ ga-ehichapụ ndekọ ahụ na chenweiliang_id 3 na tebụl chenweiliang_tbl:

Hichapụ data site na iji script PHP

PHP na-eji mysqli_query() ọrụ iji mejuputa nkwupụta SQL.Ị nwere ike iji nkeji okwu WHERE nwere ma ọ bụ na-enweghị iwu SQL DELETE.

Ọrụ a na-arụ ọrụ MySQL> Mmetụta nke agwa iwu na-emezu iwu SQL bụ otu ihe ahụ.

ihe atụ

Ihe atụ PHP na-esote ga-ehichapụ ndekọ ahụ na chenweiliang_id 3 na tebụl 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);
?>