ALTER SEQUENCE

SEQUENCE[CHANGE TO NEW|TIME]START WITH 参数说明 参数 说明 START WITH Sequence的起始值,无默认值,若未指定则忽略该参数,在转换类型时必须指定。说明 转换到Time-based Sequence时,指定起始值无意义。Time-based Sequence语法ALTER ...

显式用法

START WITH]参数说明 参数 说明 START WITH Group Sequence 的起始值,若未指定,则默认起始值为100001。示例 方法一mysql>CREATE SEQUENCE seq1;方法二mysql>CREATE GROUP SEQUENCE seq1;单元化 Group Sequence 语法CREATE[GROUP]SEQUENCE...

CREATE SEQUENCE

New Sequence语法CREATE[NEW]SEQUENCE[START WITH]参数说明 参数 说明 START WITH New Sequence的起始值,若未指定,则默认起始值为1。说明 如果未指定类型关键字,在AUTO模式数据库中默认创建New Sequence,DRDS模式数据库不支持创建New ...

选择根节点

START WITH子句用于确定由table_expression选择的要用作根节点的行。由table_expression选择且start_expression计算结果为true的所有行都将成为树的根节点。于是,结果集中潜在树的数量等于根节点的数量。因此,如果省略START WITH子句,则...

刷新物化视图

[START WITH date][NEXT date]]说明 目前仅支持全量刷新(COMPLETE)。手动刷新#手动触发一次刷新 REFRESH MATERIALIZED VIEW 全量刷新模式 创建物化视图时默认为全量刷新模式。全量刷新会计算刷新时刻的查询结果,并且用覆盖的方式替换...

ALIYUN:VPC:NatIp

underscores(_),and hyphens(-).It must start with a letter.It cannot start\nwith http:// or https://.","MinLength":2,"MaxLength":128 }, NatGatewayId":{"Type":"String","Description":"The ID of the Virtual Private Cloud(VPC)...

ALIYUN:VPC:CustomerGateway

characters and must start with a letter or Chinese.It can contain numbers, periods(.),underscores(_),and dashes(-).But it can't start with http:// or https://.","MaxLength":128 } },"Outputs":{"CustomerGatewayId":{ ...

ALIYUN:ECS:HpcCluster

characters in length.It must\nstart with a letter but cannot start with http:// or https://. It can contain letters,\ndigits,colons(:),underscores (_),and hyphens(-)."},"Description":{"Type":"String","Description": The ...

创建物化视图

WITH和NEXT 定义自动进行全量刷新物化视图时的首次刷新时间(即START WITH)和下次刷新时间(即NEXT)。说明 START WITH参数选填,若不填,默认首次刷新时间为当前时间点。若需要设置自动刷新,NEXT参数必填。支持使用时间函数,但只支持...

ALIYUN:SAG:ACL

start with a letter or Chinese.It can contain numbers,periods(.), underscores(_)and dashes(-),but cannot start with http:// or https://." } },"Outputs":{"AclId":{"Description":"Access control set ID.","Value":{ Fn:GetAtt...

SHOW HELP

本文介绍了如何使用SHOW HELP命令。操作样例 SHOW HELP用于展示PolarDB-X 1.0...[start with COUNT]|Alter sequence|alter sequence test start with 100000| drop sequence NAME|Drop sequence|drop sequence test| 20 rows in set(0.00 sec)

ALIYUN:VPC:EIPPro

be 2 to 256 characters in length.It must start with a letter.It cannot start with http:// or https://. Default: test InstanceId: Type: String Description: The ID of the requested EIP.Default:eip-25877c70gddh*Name:Type:...

CREATE SEQUENCE

MINVALUE minvalue }][{ NOMAXVALUE|MAXVALUE maxvalue }][START WITH start [CACHE cache|NOCACHE][CYCLE]说明 CREATE SEQUENCE 可创建新的序列号生成器。这涉及到创建并初始化一个新的特殊的单行表,其名称为 name。生成器将由发布命令的...

概述

分层查询是一种查询类型,它根据构成父子关系的数据按层次顺序...与分层查询相关的子句 START WITH、CONNECT BY 和 ORDER SIBLINGS BY 将在以下各节中予以介绍。说明 目前PolarDB O引擎不支持在 CONNECT BY 子句中使用 AND(或其他运算符)。

ALIYUN:CEN:CenBandwidthPackage

A-Z,0-9,periods,underlines,and hyphens.It must start with English letters, but cannot start with http:// or https://. Resources: CenBandwidthPackage: Type:'ALIYUN:CEN:CenBandwidthPackage' Properties:Description:Ref: ...

示例应用程序中的组织树

START WITH mgr IS NULL 子句仅选择 KING 作为初始根节点。下面显示了完整的 SELECT 命令。SELECT ename,empno,mgr FROM emp START WITH mgr IS NULL CONNECT BY PRIOR empno=mgr;该查询输出中的行按从上到下、从左到右的顺序移动,从根到...

创建与使用序列

MINVALUE minvalue }][{ NOMAXVALUE|MAXVALUE maxvalue }][START WITH start][CACHE cache|NOCACHE][CYCLE]参数 参数名称 描述 name 创建的序列的名称。increment 您可以使用可选的 INCREMENT BY increment子句把当前序列的值加上指定增量...

ALIYUN:VPC:SslVpnClientCert

2-128 characters and must start with a letter or Chinese.It can contain numbers,periods(.),underscores(_),and dashes(-).But it can't start with http:// or https://.","MaxLength":128 },"SslVpnServerId":{"Type": String",...

ALIYUN:REDIS:Account

account.The name must start with a lowercase letter and can contain\nlowercase letters,digits,and underscores(_).The name can be 1 to 16 characters\nin length."},"AccountPrivilege":{"Type":"String","Description":"The ...

SHOW HELP

[start with COUNT]|Alter sequence|alter sequence test start with 100000| drop sequence NAME|Drop sequence|drop sequence test|show db status| Report size of each physical database|show db status|show full db status Report ...

ALIYUN:SAG:Qos

(-).It must start with a letter."},"QosDescription":{"Type":"String", Description":"The description of the QoS policy.\nThe description must be 1 to 512 characters in length and can contain letters,digits,\nunderscores(_)...

ALIYUN:VPC:NetworkAcl

(_),and hyphens(-).The name must start with a letter and cannot\nstart with http:// or https://." } },"Resources":{"NetworkAcl":{"Type": ALIYUN:VPC:NetworkAcl","Properties":{"IngressAclEntries":{"Ref": IngressAclEntries...

ALIYUN:SAG:CloudConnectNetwork

underlines,&and hyphens.The name must start with an English letter,but cannot start with&http:// or https://.' & & Type: String & Tags: & & Description:Tags to attach to instance.Max support 20 tags to add during create&...

ALIYUN:VPC:RouteTable

letters,numbers,periods(.),underscores(_),and hyphens(-).It must start with a letter and cannot start with http:// or https://. VpcId: Type: String AssociationProperty:ALIYUN:ECS:VPC:VPCId Resources:RouteTable:Type: ...

ALIYUN:VPC:DhcpOptionsSet

hyphens(-).It must start with a letter or a Chinese character.","Default": test"},"DhcpOptionsSetDescription":{"Type":"String","Description":"The description of the DHCP options set.\nThe description must be 2 to 256 ...

获取待导入资源的标识符属性

to 256 characters in length.It must start with a letter.It cannot start with http:// or https://." },"ResourceGroupId":{"Type":"String","Description": Resource group id."},"InstanceChargeType":{"Type":"String", ...

定义父/子关系

包含CONNECT BY子句的SELECT命令通常包含START WITH子句。说明 START WITH子句确定要作为根节点的行,这些行是要应用前面描述的算法的初始父节点,具体请参见选择根节点。示例 创建城市归属表。CREATE TABLE chinamap(id INT,parentid INT,...

对同级排序

LPAD(' ',2*(LEVEL-1))|ename"employee",empno,mgr FROM emp START WITH mgr IS NULL CONNECT BY PRIOR empno=mgr ORDER SIBLINGS BY ename ASC;上一查询的输出现在也进行了修改,因此同级按名称的升序显示。同级 BLAKE、CLARK 和 JONES ...

使用CONNECT_BY_ROOT检索根节点

CONNECT_BY_ROOT 运算符不能在分层查询的 CONNECTBY 子句或 START WITH 子句中使用。可将 CONNECT_BY_ROOT 应用于一个涉及列的表达式,但这样做时,该表达式必须用圆括号括起。以下查询显示了如何使用 CONNECT_BY_ROOT 运算符根据以员工 ...

ALIYUN:GPDB:Account

lowercase letter or a digit.\nThe name cannot start with gp.\nThe name must be 2 to 16 characters in length."} },"Resources":{"Account":{"Type": ALIYUN:GPDB:Account","Properties":{"DBInstanceId":{"Ref": DBInstanceId"},...

ALIYUN:ALB:Acl

hyphens(-)and underscores(_).It must start with a letter.","MinLength":2, MaxLength":128 } },"Resources":{"Acl":{"Type":"ALIYUN:ALB:Acl", Properties":{"AclEntries":{"Ref":"AclEntries"},"AclName":{"Ref": AclName"} } } },...

错误码

invalid.QueueName should start with alpha and contain only alpha,digit or-. 400 队列名称不合法。具体信息,请参见对应API文档。QueueNameLengthError Queue name length should between 1 and 255.400 队列名称不合法。具体信息,请...

CheckBlockVolumeName

The specified endpoint for the bucket is invalid.The Endpoint must start with oss-and end with.aliyuncs.com. 无效的Bucket Endpoint,Endpoint必须以“oss-”开头,以“.aliyuncs.com”结束。400 InvalidVolumeName The specified ...

ALIYUN:POLARDB:Account

The description must comply with the following rules:\n-It cannot start with http:// or https://.\n- It must be 2 to 256 characters in length.", MinLength":2,"MaxLength":256 },"AccountPrivilege":{"Type":"String", ...

ALIYUN:ApiGateway:Plugin

must be 4 to 50 characters in length and cannot start with an underscore(). },"Description":{"Type":"String","Description":"The description of the plug-in,which cannot exceed 200 characters."},"PluginData":{"Type": String...

CONNECT BY 子句

CONNECT BY 子句一起指定:START WITH start_expression由 FROM 子句(start_expression 的求值结果为 TRUE)返回的行将成为层次结构的根节点。ORDER SIBLINGS BY expression[ASC|DESC][, 层次结构的同级行按结果集中的 expression 排序。...

错误码表

QueueName should start with alpha and contain only alpha,digit or-. TopicNameInvalid 主题名称无效 The topic name you provided is invalid.TopicName should start with alpha or digit and contain only alpha,digit or-. ...

创建作业(DAG类型)

[a-zA-Z0-9_-],and must not start with[0-9].Name中只能包括字母数字和_-,但不能以数字开头。400 InvalidDescription Specified parameter Description is not valid.Its type must be string.Description必须是一个string。400 ...

GetResourceTypeTemplate

block cannot start with 0.2.The subnet mask must be 8 to 24 bits in length. The secondary CIDR block cannot overlap with the primary CIDR block or an existing secondary CIDR block.String Resource group id.String The IP ...

DATASOURCE:VPC:NetworkAcls

digits,underscores(_),and hyphens(-).The name must start with a letter but cannot start with http:// or https://." } },"Resources":{ ExtensionDataSource":{"Type":"DATASOURCE:VPC:NetworkAcls","Properties": {"NetworkAclName...
共有138条 < 1 2 3 4 ... 138 >
跳转至: GO
新人特惠 爆款特惠 最新活动 免费试用