检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Precautions The owner of a table, users granted with the DELETE permission on the table, or users granted with the DELETE ANY TABLE permission can delete data from the table.
Suggestions delete To delete all records in a table, use the truncate syntax.
The DELETE statement must contain the WHERE clause to avoid full table scanning. Do not use the ORDER BY or GROUP BY clause in the DELETE statement to avoid unnecessary sorting. Use TRUNCATE instead of DELETE to clear a table.
Precautions The owner of a table, users granted with the DELETE permission on the table, or users granted with the DELETE ANY TABLE permission can delete data from the table.
Precautions The owner of a table, users granted the DELETE permission on the table or the DELETE ANY TABLE permission can delete data from the table. When separation of duties is disabled, system administrators have this permission by default.
Precautions The owner of a table, users granted with the DELETE permission on the table, or users granted with the DELETE ANY TABLE permission can delete data from the table.
Precautions The owner of a table, users granted with the DELETE permission on the table, or users granted with the DELETE ANY TABLE permission can delete data from the table.
After INSERT of T1 is complete, T1 is committed and DELETE of T2 is executed. In this case, DELETE 0 is displayed, because the data obtained in queries is consistent in a transaction. Parent topic: Concurrent Write Examples
After INSERT of T1 is complete, T1 is committed and DELETE of T2 is executed. In this case, DELETE 0 is displayed, because the data obtained in queries is consistent in a transaction. Parent topic: Concurrent Write Examples
How Can I Delete the GaussDB Backup Policy? Sorry, you cannot delete the GaussDB backup policy. When you create a GaussDB instance, the instance-level automated backup policy is enabled by default. You can modify the backup cycle and retention period on the console.
The TRUNCATE statement can delete all data in a table but does not delete the table structure. The deletion speed of the DELETE statement is the slowest. You can delete data from a table based on conditions, excluding the table structure. Parent topic: FAQ
The TRUNCATE statement can delete all data in a table but does not delete the table structure. The deletion speed of the DELETE statement is the slowest. You can delete data from a table based on conditions, excluding the table structure. Parent topic: FAQs
How Do I Enable the Audit of INSERT, UPDATE, and DELETE Operations in GaussDB? You can enable the audit of INSERT, UPDATE, and DELETE operations on the GaussDB console. Specifically, perform the following operations: Log in to the management console.
If the dependent objects are other databases or reside in other databases, manually delete them before deleting the user from the current database. DROP USER cannot delete objects across databases.
If the dependent objects are other databases or reside in other databases, manually delete them before deleting the user from the current database. DROP USER cannot delete objects across databases.
On the displayed page, locate the task record to be deleted and click Delete in the Operation column. In the displayed dialog box, click OK. You can delete tasks in the following statuses: Completed Failed Parent Topic: Task Center
Deleting a Pay-per-Use GaussDB Instance Scenarios You need to delete unnecessary DB instances. You need to delete the DB instance that fails to be created. Deleted DB instances cannot be recovered. Exercise caution when performing this operation.
Deleting a Level-2 Partition from a Level-2 Partitioned Table You can run ALTER TABLE DROP SUBPARTITION to delete a level-2 range or list partition from a level-2 partitioned table.
Deleting a Level-2 Partition from a Level-2 Partitioned Table You can run ALTER TABLE DROP SUBPARTITION to delete a level-2 range or list partition from a level-2 partitioned table.
For example, delete the partition date_202005 from the range partitioned table range_sales by specifying the partition name and update the global index.