mysql自动递增删除,mysql - 删除记录时如何以自动递增为约束递减列上的序列 - 堆栈内存溢出...

通过递减1(-1)更新所有已删除的ID(如果auto_increment列中有3个ID，并且您删除了ID 2，则ID 3将被设置为ID = 2)，然后“更改表集” auto_increment = 1以更新auto_increment计数器代码(包括从网站文件夹中删除图像文件：

$allGood = false;

if(isset($_GET['id']) != ""){

$item = $_GET['id'];

$query = "SELECT * FROM products WHERE id = ?";

if($getImgPath = $sqlConnection->prepare($query)){

$getImgPath->bind_param("i",$item);

$getImgPath->execute();

$result = $getImgPath->get_result();

$row = $result->fetch_array();

$deletedItemId = $row['id'];

if(isset($row['image']) != ""){

$imgPath = "../../../../".$row['image'];

if(unlink($imgPath)){

$query = "DELETE FROM products WHERE id = ?";

if($delete = $sqlConnection->prepare($query)){

$delete->bind_param("i",$item);

if($delete->execute()){

$query = "SELECT * FROM products";

if($getIds = $sqlConnection->query($query)){

while($row = $getIds->fetch_array()){

if($row['id']>$deletedItemId){

$newId = $row['id']-1;

$query = "UPDATE products SET id=? WHERE id=?";

if($updateIds = $sqlConnection->prepare($query)){

$updateIds->bind_param("ii",$newId,$row['id']);

if($updateIds->execute()){

$allGood = true;

}

}

} else {$allGood = true;}

}

}

}

}

}

}

}

}

if($allGood == true){

$query = "ALTER TABLE products AUTO_INCREMENT = 1";

if($sqlConnection->query($query)){

echo "success!";

}else{echo "error.";}

}