mysql - 只需合并 2 个删除查询即可使其成为一个

Question

我有 2 个删除 SQL 查询，我想将其设为一个。

$sql1= DELETE FROM user WHERE userid={$id}

另一个是

$sql = Delete FROM user_meta where userid = {$id}

有什么建议吗？我想让事情变得简单。

Answer 1

“同时”从不同表中删除内容的正常方法是将它们包装在事务中。像这样的东西:

begin transaction thedeletes
    DELETE FROM user WHERE userid={$id};
    DELETE FROM user_meta WHERE userid = {$id}
commit transaction thedeletes;

在 MySQL 中，您实际上可以将它们放在同一个查询中:

delete u, um
    from user u join
         user_meta um
         on u.userid={$id} and um.userid = {$id};