如何从ID列表中的ID表中删除？ [英] How to delete from a table where ID is in a list of IDs?

问题描述

如果我有一个ID列表（1、4、6、7）和一个数据库表，我想删除该列表中ID所在的所有记录，那该怎么做？

if I have a list of IDs (1,4,6,7) and a db table where I want to delete all records where ID is in this list, what is the way to do that?

推荐答案

您的问题为此几乎拼写了SQL：

Your question almost spells the SQL for this:

DELETE FROM table WHERE id IN (1, 4, 6, 7)

这篇关于如何从ID列表中的ID表中删除？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！