gpt4 book ai didi

sql - 删除和删除数据库有什么区别?

转载 作者:行者123 更新时间:2023-12-04 16:15:38 25 4
gpt4 key购买 nike

删除和删除数据库有什么区别?

最佳答案

Difference between DELETE and DROP commands

Delete: The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation you need to COMMIT or ROLLBACK the transaction to make the change permanent or to undo it. Note that this operation will cause all DELETE triggers on the table to fire.

Drop: The DROP command removes a table from the database. All the tables' rows, indexes and privileges will also be removed. No DML triggers will be fired. The operation cannot be rolled back.

关于sql - 删除和删除数据库有什么区别?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/2452524/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com