mysql - 如何在一条语句中合并插入查询和删除查询？

Question

如何将这两个查询组合成单个查询

$sql = "INSERT INTO deletedtemplate (template) SELECT template FROM template WHERE id = $id";

$sql1 = "DELETE FROM template WHERE id = $id ";

Answer 1

您可以简单地将这两个查询结合使用:

$sql = "INSERT INTO deletedtemplate (template) SELECT template FROM template WHERE id = $id; DELETE FROM template WHERE id = $id ";