思维导图备注

CockroachDB v19.1 Documents
首页 白天 夜间 BookChat 小程序 小程序 阅读
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签

SQL Syntax

 来源:cockroachlabs.com 浏览 729 扫码 分享 2019-05-12 09:53:00
    • Full SQL Grammar
    • Keywords & Identifiers
    • Constants
    • Selection Queries
    • Ordering Query Results
    • Limiting Query Results
    • Table Expressions
    • Common Table Expressions
    • Join Expressions
    • Computed Columns
    • Scalar Expressions
    • Subqueries
    • Name Resolution
    • AS OF SYSTEM TIME
    • NULL Handling
    当前内容版权归 cockroachlabs.com 或其关联方所有，如需对内容或内容相关联开源项目进行关注与资助，请访问 cockroachlabs.com .
    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • Guides
      • Get Started
        • Install CockroachDB
        • Start a Local Cluster
          • From Binary
          • In Kubernetes
          • In Docker
        • Learn CockroachDB SQL
        • Build an App
          • Overview
          • Go
          • Python
          • Ruby
          • Java
          • Node.js
          • C++
          • C# (.NET)
          • Clojure
          • PHP
          • Rust
      • Deploy
        • Production Checklist
        • Cluster Topology Patterns
        • Test Deployment
        • Manual Deployment
          • Overview
          • On-Premises
          • AWS
          • Azure
          • Digital Ocean
          • Google Cloud Platform GCE
        • Orchestrated Deployment
          • Overview
          • Kubernetes Single-Cluster Deployment
          • Kubernetes Multi-Cluster Deployment
          • Kubernetes Performance Optimization
          • Docker Swarm Deployment
          • Mesosphere DC/OS Deployment
        • Security
          • Overview
          • Authentication
          • Encryption
          • Authorization
          • SQL Audit Logging
          • GSSAPI Authentication
        • Monitoring and Alerting
          • Overview
          • Use the Admin UI
          • Enable the Node Map
          • Use Prometheus and Alertmanager
        • Configure Replication Zones
        • Performance Benchmarking
        • Performance Tuning
        • Table Partitioning
        • Change Data Capture
        • Enterprise Features
      • Migrate
        • Migration Overview
        • Migrate from Postgres
        • Migrate from MySQL
        • Migrate from CSV
      • Maintain
        • Upgrade to CockroachDB v19.1
        • Manage Long-Running Queries
        • Decommission Nodes
        • Import Data
        • Back up and Restore Data
        • Create a File Server for IMPORT/BACKUP
        • Rotate Security Certificates
      • Troubleshoot
        • Overview
        • Common Errors
        • Troubleshoot Cluster Setup
        • Troubleshoot Query Behavior
        • Understand Debug Logs
        • Support Resources
        • File an Issue
      • Contribute
        • Contribute to CockroachDB
        • Improve the Docs
    • Tutorials
      • Geo-Partitioning
      • Data Replication
      • Fault Tolerance & Recovery
      • Automatic Rebalancing
      • Serializable Transactions
      • Cross-Cloud Migration
      • Follow-the-Workload
      • Orchestration with Kubernetes
      • JSON Support
    • Reference
      • SQL
        • Supported Client Drivers
        • Client Connection Parameters
        • SQL Feature Support
          • SQL Support Summary
          • Detailed SQL Standard Comparison
        • SQL Statements
          • Overview
          • ADD COLUMN
          • ADD CONSTRAINT
          • ALTER COLUMN
          • ALTER DATABASE
          • ALTER INDEX
          • ALTER RANGE
          • ALTER SEQUENCE
          • ALTER TABLE
          • ALTER TYPE
          • ALTER USER
          • EXPERIMENTAL_AUDIT
          • ALTER VIEW
          • BACKUP (Enterprise)
          • BEGIN
          • CANCEL JOB
          • CANCEL QUERY
          • CANCEL SESSION
          • COMMENT ON
          • COMMIT
          • CONFIGURE ZONE
          • CREATE CHANGEFEED (Enterprise)
          • CREATE DATABASE
          • CREATE INDEX
          • CREATE ROLE (Enterprise)
          • CREATE SEQUENCE
          • CREATE STATISTICS
          • CREATE TABLE
          • CREATE TABLE AS
          • CREATE USER
          • CREATE VIEW
          • DELETE
          • DROP COLUMN
          • DROP CONSTRAINT
          • DROP DATABASE
          • DROP INDEX
          • DROP ROLE (Enterprise)
          • DROP SEQUENCE
          • DROP TABLE
          • DROP USER
          • DROP VIEW
          • EXPERIMENTAL CHANGEFEED FOR
          • EXPLAIN
          • EXPLAIN ANALYZE
          • EXPORT (Enterprise)
          • GRANT <privileges>
          • GRANT <roles> (Enterprise)
          • IMPORT
          • INSERT
          • PARTITION BY (Enterprise)
          • PAUSE JOB
          • RENAME COLUMN
          • RENAME CONSTRAINT
          • RENAME DATABASE
          • RENAME INDEX
          • RENAME TABLE
          • RENAME SEQUENCE
          • RELEASE SAVEPOINT
          • RESET
          • RESET CLUSTER SETTING
          • RESTORE (Enterprise)
          • RESUME JOB
          • REVOKE <privileges>
          • REVOKE <roles> (Enterprise)
          • ROLLBACK
          • SAVEPOINT
          • SELECT
          • SET
          • SET CLUSTER SETTING
          • SET TRANSACTION
          • SHOW
          • SHOW BACKUP
          • SHOW CLUSTER SETTING
          • SHOW COLUMNS
          • SHOW CONSTRAINTS
          • SHOW CREATE
          • SHOW DATABASES
          • SHOW EXPERIMENTAL_RANGES
          • SHOW GRANTS
          • SHOW INDEX
          • SHOW JOBS
          • SHOW QUERIES
          • SHOW ROLES
          • SHOW SCHEMAS
          • SHOW SEQUENCES
          • SHOW SESSIONS
          • SHOW STATISTICS
          • SHOW TABLES
          • SHOW TRACE FOR SESSION
          • SHOW USERS
          • SHOW ZONE CONFIGURATIONS
          • SPLIT AT
          • TRUNCATE
          • UPDATE
          • UPSERT
          • VALIDATE CONSTRAINT
        • Data Types
          • Overview
          • ARRAY
          • BIT
          • BOOL
          • BYTES
          • COLLATE
          • DATE
          • DECIMAL
          • FLOAT
          • INET
          • INT
          • INTERVAL
          • JSONB
          • SERIAL
          • STRING
          • TIME
          • TIMESTAMP
          • UUID
        • Constraints
          • Overview
          • Check
          • Default Value
          • Foreign Key
          • Not Null
          • Primary Key
          • Unique
        • Functions and Operators
        • SQL Syntax
          • Full SQL Grammar
          • Keywords & Identifiers
          • Constants
          • Selection Queries
          • Ordering Query Results
          • Limiting Query Results
          • Table Expressions
          • Common Table Expressions
          • Join Expressions
          • Computed Columns
          • Scalar Expressions
          • Subqueries
          • Name Resolution
          • AS OF SYSTEM TIME
          • NULL Handling
        • Transactions
        • Views
        • Window Functions
        • Performance Optimization
          • SQL Best Practices
          • Indexes
          • Inverted Indexes
          • Column Families
          • Interleaved Tables
          • Parallel Statement Execution
        • Information Schema
        • Porting Applications
          • From PostgreSQL
        • Experimental Features
      • CLI
        • Overview
        • cockroach start
        • cockroach init
        • cockroach cert
        • cockroach quit
        • cockroach sql
        • cockroach sqlfmt
        • cockroach user
        • cockroach node
        • cockroach dump
        • cockroach demo
        • cockroach debug encryption-active-key
        • cockroach debug merge-logs
        • cockroach debug zip
        • cockroach gen
        • cockroach version
        • cockroach workload
      • Cluster Settings
        • Cluster Settings Overview
        • Cost-Based Optimizer
        • Follower Reads
        • Load-Based Splitting
        • Range Merges
      • Admin UI
        • Admin UI Overview
        • Cluster Overview Page
        • Overview Dashboard
        • Hardware Dashboard
        • Runtime Dashboard
        • SQL Dashboard
        • Storage Dashboard
        • Replication Dashboard
        • Changefeeds Dashboard
        • Databases Page
        • Statements Page
        • Jobs Page
        • Advanced Debugging Page
        • Custom Chart Debug Page
      • Third-Party Database Tools
        • Overview
        • DBeaver
        • IntelliJ IDEA
      • Diagnostics Reporting
    • Concepts
      • Architecture
        • Overview
        • SQL Layer
        • Transaction Layer
        • Distribution Layer
        • Replication Layer
        • Storage Layer
        • Life of a Distributed Transaction
        • Reads and Writes Overview
      • Features
        • Multi-Active Availability
        • Simplified Deployment
        • Strong Consistency
        • SQL
        • Distributed Transactions
        • Online Schema Changes
        • Automated Scaling & Repair
        • High Availability
        • Open Source
        • Go Implementation
    • FAQs
      • Product FAQs
      • SQL FAQs
      • Operational FAQs
      • CockroachDB in Comparison
    • Releases
      • v19.1.0
      • v2.1.6
      • v2.1
      • v2.0.7
      • v2.0
      • All Production Releases
    暂无相关搜索结果！

      本文档使用 BookStack 构建

      展开/收起文章目录

      分享，让知识传承更久远

      文章二维码

      手机扫一扫，轻松掌上读

      文档下载

      • 普通下载
      • 下载码下载(免登录无限下载)
      你与大神的距离，只差一个APP
      APP下载
      请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
      PDF文档 EPUB文档 MOBI文档
      温馨提示 每天每在网站阅读学习一分钟时长可下载一本电子书，每天连续签到可增加阅读时长
      下载码方式下载：免费、免登录、无限制。 免费获取下载码

      微信小程序阅读

      BookChat 微信小程序阅读
      您与他人的薪资差距，只差一个随时随地学习的小程序

      书签列表

        阅读记录

        阅读进度: 0.00% ( 0/0 ) 重置阅读进度