blocks|key|1318606|text|DELETE+Content,+Votes
FROM+Content
LEFT+JOIN+Votes
ON+Votes.ContentID+=+Content.ContentID
WHERE+Content.ContentID+=+?|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1318607|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>DELETE Content, Votes
FROM Content
LEFT JOIN Votes
ON Votes.ContentID = Content.ContentID
WHERE Content.ContentID = ?
</code></pre>

blocks|key|2701482|text|如果您有关系，可以尝试使用这个删除级联选项。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2701483|另一种选择是创建一个存储过程，并在两个步骤中执行删除，但只使用一个服务器调用。|2701484|entityMap^0|J|3|0|0|13|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

If you have a relation you can try with this ON DELETE CASCADE option.

Another option is to create a stored procedure and do the delete in 2 steps but with only one server call.

blocks|key|2701421|text|DELETE+t1,+t2+FROM+t1+INNER+JOIN+t2+INNER+JOIN+t3
WHERE+t1.id=t2.id+AND+t2.id=t3.id;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2701422|虽然这是三张桌子，但我相信你可以根据你的需要来调整它。|unstyled|2701423|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>DELETE t1, t2 FROM t1 INNER JOIN t2 INNER JOIN t3
WHERE t1.id=t2.id AND t2.id=t3.id;
</code></pre>

Although this is for 3 tables, I'm sure you'll be able to adapt it to your needs.

blocks|key|2701502|text|可以在DELETE语句中指定多个表，以便根据WHERE子句中的特定条件从一个或多个表中删除行。但是，不能在多表删除中使用ORDER或ORDER.table_references子句列出了连接中涉及的表。其语法在12.2.7.1节“联接语法”中进行了描述。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2701503|支持从MySQL+4.0.0开始的第一个多表删除语法。第二个支持从MySQL+4.0.2开始。|2701504|对于第一个多表语法，只删除from子句之前列出的表中的匹配行。对于第二种多表语法，只删除from子句中列出的表(在are子句之前)中列出的表中的匹配行。其效果是，您可以同时从多个表中删除行，并具有仅用于搜索的附加表：|2701505|DELETE+t1,+t2+FROM+t1+INNER+JOIN+t2+INNER+JOIN+t3+WHERE+t1.id=t2.id+AND+t2.id=t3.id;|code-block|syntax|javascript|2701506|或：|offset|length|style|BOLD|2701507|DELETE+FROM+t1,+t2+USING+t1+INNER+JOIN+t2+INNER+JOIN+t3+WHERE+t1.id=t2.id+AND+t2.id=t3.id;|2701508|这些语句在搜索要删除的行时使用所有三个表，但只从表t1和t2中删除匹配行。|2701509|此链接可能是有用的"http://dev.mysql.com/doc/refman/4.1/en/delete.html“。|2701510|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/4.1/en/delete.html^0|0|0|0|0|0|2|0|0|0|A|1E|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|16|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|17|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|18|8|@$M|19|N|1A|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|H|7|1B|8|@]|9|@]|A|$I|J]]|$1|S|3|T|5|6|7|1C|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1D|8|@]|9|@$M|1E|N|1F|1|1G]]|A|$]]|$1|W|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]]]

You can specify multiple tables in a DELETE statement to delete rows from one or more tables depending on the particular condition in the WHERE clause. However, you cannot use ORDER BY or LIMIT in a multiple-table DELETE. The table_references clause lists the tables involved in the join. Its syntax is described in Section 12.2.7.1, “JOIN Syntax”.

The first multiple-table DELETE syntax is supported starting from MySQL 4.0.0. The second is supported starting from MySQL 4.0.2.

For the first multiple-table syntax, only matching rows from the tables listed before the FROM clause are deleted. For the second multiple-table syntax, only matching rows from the tables listed in the FROM clause (before the USING clause) are deleted. The effect is that you can delete rows from many tables at the same time and have additional tables that are used only for searching:

<pre><code>DELETE t1, t2 FROM t1 INNER JOIN t2 INNER JOIN t3 WHERE t1.id=t2.id AND t2.id=t3.id;
</code></pre>

Or:

<pre><code>DELETE FROM t1, t2 USING t1 INNER JOIN t2 INNER JOIN t3 WHERE t1.id=t2.id AND t2.id=t3.id;
</code></pre>

These statements use all three tables when searching for rows to delete, but delete matching rows only from tables t1 and t2. 

This link can be useful "<a href="http://dev.mysql.com/doc/refman/4.1/en/delete.html" rel="nofollow noreferrer">http://dev.mysql.com/doc/refman/4.1/en/delete.html</a>"

blocks|key|1320209|text|在没有使用“联接”的情况下，我在寻找解决方案时能想到的最简单的方法是DELETE+a.*,b.*+FROM+table1+AS+a,+table2+AS+b+WHERE+a.id+=+b.id+AND+a.field+=+1。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1320210|entityMap^0|Y|26|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Without using "JOINS" the simplest I could come up with while I was searching for a solution was <code>DELETE a.*,b.* FROM table1 AS a, table2 AS b WHERE a.id = b.id AND a.field = 1</code>

I'm looking to delete information in two different tables in 1 query, based on an ID.

I've tried several solutions on here to accomplish this task but still have not accomplished what I'm trying to do.

Table 1 - Content

<pre><code>---------- ---------
 ContentID | Content
--------------------
</code></pre>

Table 2 - Votes

<pre><code>---------------------------
 VoteID | ContentID | Vote 
---------------------------
</code></pre>

I want to delete the content row based on its ID and any or all votes (there could be 0 vote records). I do NOT want to use transactions, cascading deletes, or use 2 different queries. 

What is best here - a LEFT JOIN? INNER JOIN?

Any help here would be greatly appreciated.

MySQL Delete Records from 2 Tables

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我希望根据ID在1个查询中删除两个不同表中的信息。我在这里尝试过几个解决方案来完成这个任务，但仍然没有完成我想要做的事情。表1-内容---------- --------- ContentID | Content--------------------表2-选票--------------------------- VoteID | ContentID | Vote ---------------

问MySQL从2个表中删除记录
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL从2个表中删除记录EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL从2个表中删除记录
EN