检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Method 2: Delete the table alias, for example: delete from test_code; Parent topic: Error Codes Generated During Conversion from MySQL to GaussDB
After the UGO resources are frozen: You can only view existing projects, and are not allowed to modify, delete, create projects or convert SQL statements. You can manually delete UGO. After your resources are unfrozen, you can perform operations such as creation.
Handling Suggestion Delete unnecessary tasks. Take a screenshot of the error. In the upper right corner of the console, choose Service Tickets > Create Service Ticket and contact the customer service. Parent topic: SQL Audit Errors
Handling Suggestion Delete unnecessary rule templates. Take a screenshot of the error. In the upper right corner of the console, choose Service Tickets > Create Service Ticket and contact the customer service. Parent topic: SQL Audit Errors
Handling Suggestion Delete historical projects to release disk space. If historical projects cannot be deleted, expand the disk capacity. Parent topic: Common Service Errors
Modify the JSONPath expression, delete the paths that are not supported by GaussDB, such as the asterisk (*) and condition-based filtering, and use a clear JSONB path to obtain information. 2.
To create a procedure with autonomous transactions, extract INSERT, UPDATE, and DELETE operations, commit or rollback transactions, and add IN parameters new and old.
to delete the row with old key values and then run the INSERT statement to insert a new row, for example: DELETE FROM duplicate_key_test WHERE id in (10, 3); INSERT INTO duplicate_key_test VALUES (10, 'DD'), (3, 'EE'); In this scenario, the database cannot be used to avoid data conflicts
ref_types ( dbtype VARCHAR(100) PRIMARY KEY, root_level_type VARCHAR(100) ); CREATE TABLE dbtype_objtype_map ( dbtype VARCHAR(100), object_type VARCHAR(100), is_supported INT, CONSTRAINT dbtype_objtype_map_fk_1 FOREIGN KEY (dbtype) REFERENCES ref_types(dbtype) ON DELETE
=1; Suggestion Update and delete statements one by one, for example: update sbtest2 set sbtest2.c='1'; update sbtest1 set sbtest1.id = 1; delete from test_keep1 sub where sub.id=2 and sub.id in (select id from test_keep where fatherid=1); delete from test_keep a where a.id=2 and a.fatherid
Click Delete Record above the list. Click OK to clear all the records. Parent topic: Statement Audit
Locate a template that you want to delete and click Delete in the Operation column. You can also select multiple templates and click Delete above the list. Click OK. Parent topic: Conversion Configuration
Locate a custom template to be deleted and click Delete in the Operation column. In the displayed dialog box, click OK. Parent topic: Rules
The following is an example of a deny policy: { "Version": "1.1", "Statement": [{ "Action": ["ugo:evaluationJob:delete"], "Effect": "Deny" }] } Parent topic: Permissions Management
Locate the task you want to delete and choose More > Delete in the Operation column. In the displayed dialog box, click OK. Parent topic: Statement Audit
Locate the task you want to delete and choose More > Delete in the Operation column. In the displayed dialog box, click OK. Parent topic: Database Audit
Deleting a Migration Project Function This API is used to delete a migration project. URI DELETE /v1/{project_id}/migration-projects/{migration_project_id} Table 1 Path parameters Parameter Mandatory Type Description project_id Yes String Project ID of a tenant in a region.
Deleting an Evaluation Project Function This API is used to delete an evaluation project.
After you delete related projects after the migration, UGO will delete data related to the projects.
In the migration project list, locate the project you want to delete and click Delete. In the displayed dialog box, click OK. Parent topic: Object Migration Project Management