php删除数据表中的数据的方法:可以通过mysqli_query()函数结合delete from语句来进行删除。delete from语句用于从数据库表中删除记录,语法结构为:【delete from tablewhere 条件】。
delete from 语句用于从数据库表中删除记录。
(推荐教程:php图文教程)
语法:
delete from table_namewhere some_column = some_value
persons表:
(学习视频推荐:php视频教程)
代码实现:
<?php$con=mysqli_connect("localhost","username","password","database");// 检测连接if (mysqli_connect_errno()){ echo "连接失败: " . mysqli_connect_error();}mysqli_query($con,"delete from persons where lastname='griffin'");mysqli_close($con);?>
删除后的表:
以上就是php如何删除数据表中的数据的详细内容。