如果要从任何MySQLi表中删除记录,则可以使用SQL命令 DELETE FROM .你可以在mysql>上使用这个命令.提示以及PHP之类的任何脚本.
以下是DELETE命令的通用SQL语法,用于从MySQLi表中删除数据 :
DELETE FROM table_name [WHERE Clause]
如果未指定WHERE子句,则将从给定的MySQLi表中删除所有记录.
您可以使用WHERE子句指定任何条件.
您可以一次删除单个表中的记录.
当您想要删除表中的选定行时,WHERE子句非常有用.
这将使用带有WHERE子句的SQL DELETE命令将所选数据删除到MySQLi表tutorials_inf中.
以下示例将删除记录到tutorial_inf,其名称为johar.
root@host# mysql -u root -p password; Enter password:******* mysql> use TUTORIALS; Database changed mysql> DELETE FROM tutorials_inf where name = 'johar'; Query OK, 1 row affected (0.23 sec) mysql>
您可以将带有或不带WHERE CLAUSE的SQL DELETE命令用于PHP函数 mysqli_query()的.该函数将以类似于mysql>执行的方式执行SQL命令.提示.
尝试以下示例从tutorial_inf中删除名称为althamas的记录.
<?php $dbhost = 'localhost:3306'; $dbuser = 'root'; $dbpass = ''; $dbname = 'TUTORIALS'; $conn = mysqli_connect($dbhost, $dbuser, $dbpass,$dbname); if(! $conn ) { die('Could not connect: ' . mysqli_error()); } echo 'Connected successfully<br>'; $sql = ' DELETE FROM tutorials_inf WHERE name = "althamas"'; if (mysqli_query($conn, $sql)) { echo "Record deleted successfully"; } else { echo "Error deleting record: " . mysqli_error($conn); } mysqli_close($conn); ?>
示例输出应该是这样的 -
Connected successfully Record deleted successfully