php - 从多个表中删除问题

Question

我正在尝试使用 JOIN 一次从多个表中删除，但如果由于任何原因联系人表没有任何用户数据（applebottomjeans），则下面的代码将无法正确运行。没有任何内容被删除/删除。我没有错误。

如何解决此问题以忽略该问题并仅删除帐户表数据和订阅表数据？我在这里错过了什么吗？

$user = $_GET['user_name'); // Username: applebottomjeans
  
// Delete user from records in accounts table, subscriptions table and contacts table
$sql = "DELETE FROM accounts, subscriptions, contacts 
USING accounts JOIN subscriptions JOIN contacts 
WHERE accounts.username = '$user' AND subscriptions.user_id = '$user' 
AND contacts.username = '$user' ";

if ($conn->query($sql) === TRUE) {
   echo "The users data was removed from our end.";
} else {
  echo "Error deleting user from our records. " . $conn->error;
}

标签： phpmysql