blocks|key|918676|text|有几种方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|918677|要直接删除它，请执行以下操作：|918678|SomeModel.objects.filter(id=id).delete()|code-block|syntax|javascript|918679|要从实例中删除它，请执行以下操作：|918680|instance+=+SomeModel.objects.get(id=id)
instance.delete()|918681|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

There are a couple of ways:

To delete it directly:

<pre><code>SomeModel.objects.filter(id=id).delete()
</code></pre>

To delete it from an instance:

<pre><code>instance = SomeModel.objects.get(id=id)
instance.delete()
</code></pre>

blocks|key|1133395|text|MyModel.objects.get(pk=1).delete()|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1133396|如果具有指定主键的对象不存在，这将引发异常，因为它首先尝试检索指定的对象。|unstyled|1133397|MyModel.objects.filter(pk=1).delete()|1133398|如果具有指定主键的对象不存在，并直接生成查询，则不会引发异常|1133399|DELETE+FROM+my_models+where+id=1|1133400|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|P|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$B|C]]|$1|I|3|J|5|F|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$B|C]]|$1|M|3|-4|5|F|7|T|8|@]|9|@]|A|$]]]|N|$]]

<pre><code>MyModel.objects.get(pk=1).delete()
</code></pre>

this will raise exception if the object with specified primary key doesn't exist because at first it tries to retrieve the specified object.

<pre><code>MyModel.objects.filter(pk=1).delete()
</code></pre>

this wont raise exception if the object with specified primary key doesn't exist and it directly produces the query

<pre><code>DELETE FROM my_models where id=1
</code></pre>

blocks|key|1133498|text|如果您想删除一个项目|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1133499|wishlist+=+Wishlist.objects.get(id+=+20)
wishlist.delete()|code-block|syntax|javascript|1133500|例如，如果您想删除Wishlist中的所有项目|1133501|Wishlist.objects.all().delete()|1133502|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

If you want to delete one item 

<pre><code>wishlist = Wishlist.objects.get(id = 20)
wishlist.delete()
</code></pre>

If you want to delete all items in Wishlist for example

<pre><code>Wishlist.objects.all().delete()
</code></pre>

blocks|key|918943|text|如果您想删除一个实例，则编写代码|type|unstyled|depth|inlineStyleRanges|entityRanges|data|918944|entry=+Account.objects.get(id=+5)
entry.delete()|code-block|syntax|javascript|918945|如果您想删除所有实例，请编写代码|918946|entries=+Account.objects.all()
entries.delete()|918947|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

if you want to delete one instance then write the code
<pre><code>entry= Account.objects.get(id= 5)
entry.delete()
</code></pre>
if you want to delete all instance then write the code
<pre><code>entries= Account.objects.all()
entries.delete()
</code></pre>

blocks|key|919018|text|您可以直接从管理面板中删除对象，或者也可以通过键入python3+manage.py+shell+(Linux中的python3)从交互式shell中删除特定的或选定的id。如果您希望用户通过浏览器(具有提供的可视界面)从数据库中删除对象(例如ID为6的员工的对象)，我们可以通过以下代码来实现:+emp+=+employee.objects.get(id=6).delete()|type|unstyled|depth|inlineStyleRanges|entityRanges|data|919019|这将删除ID为6的员工。|919020|如果您希望删除数据库中存在的所有雇员，而不是get()，请指定all()，如下所示:+employee.objects.all().delete()|919021|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

you can delete the objects directly from the admin panel or else there is also an option to delete specific or selected id from an interactive shell by typing in python3 manage.py shell (python3 in Linux).
If you want the user to delete the objects through the browser (with provided visual interface) e.g. of an employee whose ID is 6 from the database, we can achieve this with the following code,
emp = employee.objects.get(id=6).delete()
THIS WILL DELETE THE EMPLOYEE WITH THE ID is 6.
If you wish to delete the all of the employees exist in the DB instead of get(), specify all() as follows:
employee.objects.all().delete()

blocks|key|1133665|text|扩展投票最多的答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1133666|请注意，您应该将request作为参数传递给视图中的delete函数。示例如下：|1133667|from+django.shortcuts+import+redirect


def+delete(request,+id):
YourModelName.objects.filter(id=id).delete()

return+redirect('url_name')|code-block|syntax|javascript|1133668|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Extending the top voted answer.
Note that you should pass request as a parameter to your delete function in your views. An example would be like:
<pre><code>from django.shortcuts import redirect


def delete(request, id):
YourModelName.objects.filter(id=id).delete()

return redirect('url_name')
</code></pre>

blocks|key|1133698|text|它就像调用下面的代码一样简单。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1133699|SomeModel.objects.get(pk=1).delete()
#+Or
SomeModel.objects.filter(pk=1).delete()

#+SQL+equivalent
#+delete+from+table_name+where+id+=+1;|code-block|syntax|javascript|1133700|如果要根据id删除多条记录，请使用__in查询lookup|offset|length|style|CODE|1133701|SomeModel.objects.fitler(pk__in=[1,2,3,4,5,...]).delete()

#+SQL+equivalent
#+delete+from+table_name+where+id+in+(1,2,4,5,...);|1133702|如果要删除所有记录，请使用.all()检索所有查询，然后使用.delete()。|1133703|SomeModel.objects.all().delete()

#+SQL+equivalent
#+delete+from+table_name;|1133704|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.djangoproject.com/en/3.1/topics/db/queries/#field-lookups^0|0|0|H|4|N|6|0|0|0|D|6|U|9|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@$I|13|J|14|K|L]]|9|@$I|15|J|16|1|17]]|A|$]]|$1|M|3|N|5|D|7|18|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|19|8|@$I|1A|J|1B|K|L]|$I|1C|J|1D|K|L]]|9|@]|A|$]]|$1|Q|3|R|5|D|7|1E|8|@]|9|@]|A|$E|F]]|$1|S|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

It is as simple as calling the following.
<pre class="lang-py prettyprint-override"><code>SomeModel.objects.get(pk=1).delete()
# Or
SomeModel.objects.filter(pk=1).delete()

# SQL equivalent
# delete from table_name where id = 1;
</code></pre>
In case you want to remove multiple records based on id,
use the <code>__in</code> query <a href="https://docs.djangoproject.com/en/3.1/topics/db/queries/#field-lookups" rel="nofollow noreferrer">lookup</a>
<pre class="lang-py prettyprint-override"><code>SomeModel.objects.fitler(pk__in=[1,2,3,4,5,...]).delete()

# SQL equivalent
# delete from table_name where id in (1,2,4,5,...);
</code></pre>
In case you want to delete all records, use <code>.all()</code> to retrieve all queries,
then <code>.delete()</code>.
<pre class="lang-py prettyprint-override"><code>SomeModel.objects.all().delete()

# SQL equivalent
# delete from table_name;
</code></pre>

blocks|key|919229|text|delete()方法用于从database.This方法中删除模型实例，该方法会立即删除对象。此方法返回已删除对象的数量。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|919230|示例：|919231|删除一条记录：|919232|data_to_be_deleted+=+Modelname.objects.get(fieldname+=+value)
data_to_be_deleted.delete()|code-block|syntax|javascript|919233|因为get方法从queryset返回单个对象，所以只有一条记录将是deleted.If提供的值不存在，这将抛出一个error.If，表中有多条记录对应于相同的值，然后它也会抛出一个错误，所以在使用get时最好使用一个唯一的值。|919234|根据条件删除多条记录：|919235|对于基于条件的删除，在queryset上使用filter方法，然后调用delete。|919236|data_to_be_deleted+=+Modelname.objects.filter(fieldname+=+value)
data_to_be_deleted.delete()|919237|要删除所有记录：|919238|若要从数据库表中删除所有模型实例/记录，则需要对所有|919239|data_to_be_deleted+=+Modelname.objects.all()
data_to_be_deleted.delete()|919240|注意:代码可以在单行中编写为Modelname.objects.all().delete()，但为了清楚理解，我使用了多行。|919241|entityMap^0|0|8|0|0|0|0|0|0|0|0|0|0|0|E|W|0^^$0|@$1|2|3|4|5|6|7|16|8|@$9|17|A|18|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|19|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|1A|8|@]|D|@]|E|$]]|$1|J|3|K|5|L|7|1B|8|@]|D|@]|E|$M|N]]|$1|O|3|P|5|6|7|1C|8|@]|D|@]|E|$]]|$1|Q|3|R|5|6|7|1D|8|@]|D|@]|E|$]]|$1|S|3|T|5|6|7|1E|8|@]|D|@]|E|$]]|$1|U|3|V|5|L|7|1F|8|@]|D|@]|E|$M|N]]|$1|W|3|X|5|6|7|1G|8|@]|D|@]|E|$]]|$1|Y|3|Z|5|6|7|1H|8|@]|D|@]|E|$]]|$1|10|3|11|5|L|7|1I|8|@]|D|@]|E|$M|N]]|$1|12|3|13|5|6|7|1J|8|@$9|1K|A|1L|B|C]]|D|@]|E|$]]|$1|14|3|-4|5|6|7|1M|8|@]|D|@]|E|$]]]|15|$]]

The <code>delete()</code> method is used to delete model instances from a database.This method immediately deletes the object. this method returns the number of object deleted.
Example:
For deleting one record:
<pre><code>data_to_be_deleted = Modelname.objects.get(fieldname = value)
data_to_be_deleted.delete()
</code></pre>
As get method returns a single object from queryset only single record will be deleted.If value supplied doesn't exist this will throw an error.If there are multilpe records in table for same value then also it will throw an error so good practice is to use a single unique value while using get.
For deleting multiple record according to a condition:
For condition based deletion filter method is used on queryset and then delete is called.
<pre><code>data_to_be_deleted = Modelname.objects.filter(fieldname = value)
data_to_be_deleted.delete()
</code></pre>
For deleting all records:
For deletion of all model instances/records from database table you need to call delete method on all
<pre><code>data_to_be_deleted = Modelname.objects.all()
data_to_be_deleted.delete()
</code></pre>
Note: code can be written in single line as <code>Modelname.objects.all().delete()</code>, but for clear understanding, I have used multiple lines.

blocks|key|919273|text|我这样做的方式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|919274|instance+=+SomeModel.objects.get(id=1)

instance.delete()|code-block|syntax|javascript|919275|对我来说，这看起来很容易理解，这就是我使用这种方法的原因。|919276|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

The way I do it:
<pre><code>instance = SomeModel.objects.get(id=1)

instance.delete()
</code></pre>
For me it looks easy to understand, that's why I use this approach.

I want to delete a particular record. Such as
<pre><code>delete from table_name where id = 1;
</code></pre>
How can I do this in a django model?

How to delete a record in Django models?

数据库

Linux

我想删除一条特定的记录。比如delete from table_name where id = 1;我如何在django模型中做到这一点？

问如何在Django模型中删除记录？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Django模型中删除记录？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Django模型中删除记录？
EN