总结php中常用的数据库删除语句

//连接数据库$conn = mysqli_connect("localhost", "username", "password", "database");//删除一行数据$sql = "DELETE FROM table_name WHERE id = 1";mysqli_query($conn, $sql);//删除多行数据$sql = "DELETE FROM table_name WHERE id IN (1, 2, 3)";mysqli_query($conn, $sql);

//连接数据库$conn = mysqli_connect("localhost", "username", "password", "database");//删除整张表数据$sql = "TRUNCATE TABLE table_name";mysqli_query($conn, $sql);//删除表中指定行数据$sql = "TRUNCATE TABLE table_name WHERE id > 10";mysqli_query($conn, $sql);

//连接数据库$conn = mysqli_connect("localhost", "username", "password", "database");//删除整个表$sql = "DROP TABLE table_name";mysqli_query($conn, $sql);