用于删除查询的 SQL [英] SQL for delete query

问题描述

我正在尝试为我的程序编写 SQL 查询，但我就是不知道怎么做.我对 SQL 的了解不够.

I'm trying to write an SQL query for my program, but I just can't figure out how. I don't know enough SQL.

我正在尝试实施在线团队系统(针对某些网站).我有两张桌子:

I'm trying to implement an online team system (for some website). I have two tables:

teams | teamId, eventId
teammembers | teamId, userId, status

现在，我需要:删除 teammembers 中对应 teamId 的 eventId 为 1 的所有记录.

Now, I need to: delete all records in teammembers where the eventId for the corresponding teamId is 1.

我正在尝试:

delete from teammembers where teamId=teams.teamId and teams.eventId=1;

我不确定这是否真的在做我想做的事情.

I'm not sure if this is really doing what I'm trying to do.

这个查询是否错误，如果是(可能是)，我该如何编写这样的查询?

Is this query wrong, and if it is (which probably is), how can I write such a query?

推荐答案

你没有指定你的 RDBMS，所以它在 MySQL 中

You don't specify your RDBMS so here it is in MySQL

DELETE teammembers FROM teammembers
JOIN teams on teammembers.teamId = teams.teamId
WHERE teams.eventId = 1

这篇关于用于删除查询的 SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！