Call GetStructSyncExecSqlDetail to obtain the script for the execution of schema synchronization.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

Parameters

Parameter Type Is it required? Example Description
OrderId Long Yes 342153

The ticket number.
PageNumber Long No 1

page number.
PageSize Long No 20

The amount of data per page.
Tid Long No 1

The tenant has expired.

Note The information of the tenant's chart is taken from the avatar in the upper-right corner of the system. For more information, see View tenant information .
RegionId String No cn-hangzhou

Select the service region of the destination region to call this operation. For more information about the valid values, see switchegionfigure parameter description .

Note select based on the location of the application nearby.

return data

Parameter Type Example Description
RequestId String 1810E635-A2D7-428B-BAA9-85DAEB9B1A77

Id of the request
Success Boolean true

Whether the request is successful.
ErrorMessage String UnknownError

Error message.
ErrorCode String UnknownError

Error code.
StructSyncExecSqlDetail object

The detailed information about the script that is used to perform this operation.
TotalSqlCount Long 1

The total number of returned Alert Records.
ExecSql String /* origin table[helloz_bak] exist, target table[helloz_bak] not exist */\N /* Generate [helloz_bak] create table SQL */\ncreate table 'helloz_bak '(\n \'tid' bigInt (20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'primary key',\n\t' gmt_create' datetime NOT NULL COMMENT' creation time ',\n \tid' gmt_modified' datetime NOT NULL COMMENT 'number 11, time modification time (nnnint)'), NOT NULL COMMENT '(N \n\t'addr' varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'address',\n \t{{********** ('id')\n)\nDEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci\nCOMMENT='test'\n;

The following example describes the scripts that are executed.

Examples

Sample requests


     http(s)://dms-enterprise.aliyuncs.com/? descrirderizd=342153&descriageizumber=1&descriageizize=20&regionid=1&common request parameters

Sample success responses

XML Format 


     HTTP/1.1 200 OK Content-Type:application/xml <GetStructSyncExecSqlDetailResponse> <StructSyncExecSqlDetail> <ExecSql>/****** target: film@rm-uxxxxxxxx.mysql.rds.aliyuncs.com:3306 ******/ /* origin table[data_modify] exist target table[data_modify] not exist * // * Generate [data_modify] create table SQL */ create table 'data_modify ' ( 'id' bigInt (20) unsigned NOT NULL AUTO_INCREMENT COMMENT' primary key ''name' varchar(256) NOT NULL COMMENT' name ''phone' varchar(32) DEFAULT NULL COMMENT 'phone', 'sex' varchar(32) DEFAULT NULL COMMENT 'gender', 'email' varchar(256) DEFAULT NULL COMMENT 'mail', 'user_desc' varchar(1024) DEFAULT NULL COMMENT 'remark', // timescale' varchar }}}( 'id') DEFAULT CHARSET=utf8 COMMENT='Test data modification table'; /* originorin table[task_data exist], exist target table[task_data] not exist * // * Generate [task_data] create table SQL */ create table 'task_data ' ( 'id' bigInt (20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key', 'gmt_create' datetime NOT NULL COMMENT 'creation time', 'gmt_modified' datetime NOT NULL COMMENT 'modification time', 'content' text COMMENT 'test data', such as scheduling tasks like 'id' and 'id') ) DEFAULT CHARSET=utf8mb4 COMMENT task orchestration table'; Test table; </consolxecloudql> <yourotaldomainqluncount> 2</yourotaldomainqluncount> </StructSyncExecSqlDetail> <yourequestaccd> 1 <40.671 DA-9346-4254-B19D-BC5FF6BF34EC</yourequestaccor> <<descriuccess> true </GetStructSyncExecSqlDetailResponse>

JSON Format 


     HTTP/1.1 200 OK Content-Type:application/json { "StructSyncExecSqlDetail" : { "ExecSql" : "/****** target: film@rm-uxxxxxxxx.mysql.rds.aliyuncs.com:3306 ******/\n\n/* origin table[data_modify] exist target table[data_modify] not exist */\n/* generate [data_modify] create table sql */\ncreate table 'data_modify '\n 'id' bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT" primary key ",\n the 'name' varchar(256) NOT NULL COMMENT' name '\n 'phone' varchar(32) DEFAULT NULL COMMENT' telephone' \N 'sex' varchar(32) DEFAULT NULL COMMENT 'gender' \n 'email' varchar(256) DEFAULT NULL COMMENT mailbox '\n' user_desc' varchar(1024) DEFAULT NULL COMMENT 'Comment '\n PRIMARY KEY ('id')\n) DEFAULT CHARSET=utf8 COMMENT=' data modifications on the test;\n/* origin table[task_data] exist, target table[task_data] not exist */\N /* Generate [task_data] create table SQL */\ncreate table 'task_data ' (\n 'id' bigInt (20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',\n' gmt_create' datetime NOT NULL COMMENT 'creation time', \N 'gmt_modified' datetime NOT NULL COMMENT 'modification time', \N 'content' text COMMENT 'data, test data' \n PRIMMAREEEEY ('id')\n) DEFAULT CHARSET=utf8mb4 COMMENT='task orchestration test table';\n\n\n", "TotalSqqlavailability" : 2 }, "Requestaterd" : "1 E4E71 DA-9346-4254-B19D-BC5FF6BF34EC", "Ssuccess" : true}

Error code

Access error Center For more information, see error codes.