blocks|key|2495232|text|​|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2495233|📷|atomic|offset|length|2495234|如果您看到执行计划都生成了如下所示的删除脚本，则没有什么区别。|2495235|DELETE+[testtable]++WHERE+[numbers]=@1|code-block|syntax|javascript|2495236|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/ae31eb2e91ca7fa5271271acc55081a9.png|imageAlt^0|0|0|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@$E|Y|F|Z|1|10]]|A|$]]|$1|G|3|H|5|6|7|11|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|12|8|@]|9|@]|A|$L|M]]|$1|N|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U|V|-4]]]]

<a href="https://i.stack.imgur.com/WYEQZ.png" rel="noreferrer"><img src="https://i.stack.imgur.com/WYEQZ.png" alt="enter image description here"></a>There is no difference if you see the execution plan both generates delete scripts as below

<pre><code>DELETE [testtable] WHERE [numbers]=@1
</code></pre>

blocks|key|1513420|text|这两种说法没有直接区别(只是我觉得“从”中删除更容易阅读和理解)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1513421|请注意，如jarlh所述，ANSI确实需要"FROM“关键字。|1513422|另见https://msdn.microsoft.com/en-us/library/ms189835.aspx|offset|length|1513423|entityMap|0|LINK|mutability|MUTABLE|url|https://msdn.microsoft.com/en-us/library/ms189835.aspx^0|0|0|2|1I|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

There is no direct difference between the two statements
(except that I find the "DELETE FROM" easier to read and understand)

note that ANSI does require the "FROM" keyword as stated by jarlh

see also 
<a href="https://msdn.microsoft.com/en-us/library/ms189835.aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/ms189835.aspx</a>

blocks|key|2903803|text|根据MSDN，单词"from“是可选的。默认情况下不使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2903804|从…
和目标table_or_view_name，或rowset_function_limited.An可选关键字，可在DELETE关键字之间使用。|blockquote|2903805|但是，在MS+Access+(或者可能是其他数据库)中，可以使用delete+*命令删除行，因此必须从中使用。|offset|length|style|CODE|BOLD|2903806|delete+*+from+phoneBook+where....|code-block|syntax|javascript|2903807|entityMap^0|0|0|W|8|1I|1|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$]]|$1|E|3|F|5|6|7|U|8|@$G|V|H|W|I|J]|$G|X|H|Y|I|K]]|9|@]|A|$]]|$1|L|3|M|5|N|7|Z|8|@]|9|@]|A|$O|P]]|$1|Q|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|R|$]]

According to the MSDN the word "from" is optional. The default is not to use:

<blockquote>
 FROM 
 
 and the target table_or_view_name, or rowset_function_limited.An optional keyword that can be used between the DELETE keyword
</blockquote>

However in MS Access (or may be some other databases) you may delete a row using <code>delete *</code> command, so you have to use from:

<pre><code>delete * from phoneBook where....
</code></pre>

blocks|key|2903827|text|删除内容没有任何不同。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2903828|但是，FROM子句是一个功能齐全的from子句，因此您可以在JOIN中使用它。例如：|offset|length|style|CODE|2903829|delete+t
++++from+t+join
+++++++++(select+min(id)+as+minid
++++++++++from+t
++++++++++group+by+grp
+++++++++)+tt
+++++++++on+t.id+=+tt.minid;|code-block|syntax|javascript|2903830|这将删除每个grp值的最小id记录。需要在delete之后的别名指定要从哪个表中删除(虽然在本例中不允许从聚合结果中删除)。|2903831|注意:此查询用于说明性目的。这个查询没有什么问题，但这不是我在Server中实际编写这样一个查询的方式。|2903832|entityMap^0|0|3|4|U|4|0|0|6|3|L|6|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@$D|U|E|V|F|G]|$D|W|E|X|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|Y|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|Z|8|@$D|10|E|11|F|G]|$D|12|E|13|F|G]]|9|@]|A|$]]|$1|O|3|P|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|R|$]]

There is no difference in your delete.

However, the <code>FROM</code> clause is a fully functional from clause, so you can use it with <code>JOIN</code>. For instance:

<pre><code>delete t
 from t join
 (select min(id) as minid
 from t
 group by grp
 ) tt
 on t.id = tt.minid;
</code></pre>

This would delete the record with the minimum id for each <code>grp</code> value. The alias after the <code>delete</code> is needed to specify which table to delete from (although in this case, deleting from an aggregation result is not allowed).

Note: This query is for illustrative purposes. There is nothing wrong with the query, but it is not how I would actually write such a query in SQL Server.

blocks|key|2495307|text|from子句是optional..Below被剥离的版本的语法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2495308|删除|2495309|+[+TOP+(+expression+)+[+PERCENT+]+]|code-block|syntax|javascript|2495310|+[+FROM+]|2495311|+{+{+table\_alias++|2495312|来自可选关键字，可在DELETE关键字和目标table_or_view_name或rowset_function_limited之间使用。|blockquote|2495313|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|T|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|K|3|L|5|F|7|V|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|O|7|W|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|Q|$]]

The from Clause is optional..Below is stripped down version of Syntax..

DELETE 
 [ TOP ( expression ) [ PERCENT ] ] 
 [ FROM ] 
 { { table_alias 

<blockquote>
 FROM
 An optional keyword that can be used between the DELETE keyword and the target table_or_view_name, or rowset_function_limited.
</blockquote>

SQL server: 
 Difference between :

<pre><code>Delete tblxyz where id=6 
</code></pre>

and : 

<pre><code>Delete from tblxyz where id=6
</code></pre>

Is their any difference between above queries ?

SQL server: difference between DELETE <Table> and DELETE from <Table>

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

SQL服务器：以下两者之间的差异：Delete tblxyz where id=6 以及：Delete from tblxyz  where id=6他们之间的查询有什么区别吗？

问SQL server:删除<Table>和从<Table>中删除的区别
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL server:删除<Table>和从<Table>中删除的区别EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL server:删除<Table>和从<Table>中删除的区别
EN