思维导图备注

CrateDB v4.6 Reference
首页 白天 夜间 BookChat 小程序 小程序 阅读
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签

General SQL

 Github  来源:crate 浏览 254 扫码 分享 2021-08-11 08:17:49
  • General SQL

    General SQL

    • Constraints
    • Value expressions
    • Lexical structure
    当前内容版权归 crate 或其关联方所有，如需对内容或内容相关联开源项目进行关注与资助，请访问 crate .
    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • CrateDB v4.6 Reference
    • CrateDB v4.5 Reference
    • CrateDB v3.3 Reference
    • SUMMARY.md
    • Tutorials
      • Installation
      • First use
      • Create user
      • Create sharded table
      • Generate time series data
      • Normalize time series data intervals
    • How-To Guides
      • CrateDB and Linux
        • Run CrateDB on Debian GNU/Linux
        • Run CrateDB on Red Hat Linux
        • Run CrateDB on Ubuntu
      • CrateDB and containers
        • Run CrateDB on Docker
        • Run CrateDB on Kubernetes
      • CrateDB and cloud hosting
        • Run CrateDB on Amazon Web Services (AWS)
        • Run CrateDB on Microsoft Azure
      • Rolling upgrade
      • Full restart upgrade
      • Bootstrap checks
      • CrateDB multi-node setup
      • CrateDB multi-zone setup
      • Scaling CrateDB on Kubernetes
      • Memory configuration
      • Sharding guide
      • Insert performance
        • Insert methods
        • Bulk inserts
        • Parallel inserts
        • Configuration tuning for inserts
        • Testing inserts performance
      • Select performance
      • Migrating from MySQL
      • Migrating from MongoDB
      • Troubleshooting with sys-tables
      • Troubleshooting with the crate-node command
      • CrateDB on Azure IoT
      • Distributed Machine Learning At The Edge
      • Data Ingestion using Kafka and Kafka Connect
      • Data Stream Pipelines with CrateDB and StreamSets Data Collector
      • Data Enrichment using IoT Hubs, Azure Functions and CrateDB
      • CrateDB with R
      • Reports with CrateDB and Power BI Desktop
      • Real Time Reports with CrateDB and Power BI
      • Distributed Deep-Learning with CrateDB and TensorFlow
      • Troubleshooting CrateDB on Docker with jcmd
    • Reference
      • Concepts
        • Joins
        • Clustering
        • Storage and consistency
        • Resiliency
      • CLI tools
      • Configuration
        • Node-specific settings
        • Cluster-wide settings
        • Session settings
        • Logging
        • Environment variables
      • General use
        • Data definition
          • Creating tables
          • Data types
          • System columns
          • Generated columns
          • Constraints
          • Storage
          • Partitioned tables
          • Sharding
          • Replication
          • Shard allocation filtering
          • Column policy
          • Fulltext indices
          • Fulltext analyzers
          • Show Create Table
          • Views
          • Altering tables
        • Data manipulation
        • Querying
          • Selecting data
          • Joins
          • Union All
          • Refresh
          • Fulltext search
          • Geo search
        • Built-in functions and operators
          • Scalar functions
          • Aggregation
          • Arithmetic operators
          • Table functions
          • Comparison operators
          • Array comparisons
          • Subquery expressions
          • Window functions
        • User-defined functions
        • Blobs
        • Optimistic Concurrency Control
        • Information schema
      • Administration
        • System information
        • Runtime configuration
        • User management
        • Privileges
        • Authentication
          • Authentication Methods
          • Host-Based Authentication (HBA)
        • Secured communications (SSL/TLS)
        • Optimization
        • Jobs management
        • JMX monitoring
        • Snapshots
        • Cloud discovery
        • Usage Data Collector
      • SQL syntax
        • General SQL
          • Constraints
          • Value expressions
          • Lexical structure
        • SQL Statements
          • ALTER CLUSTER
          • ALTER TABLE
          • ALTER USER
          • ANALYZE
          • BEGIN
          • START TRANSACTION
          • COMMIT
          • COPY FROM
          • COPY TO
          • CREATE ANALYZER
          • CREATE BLOB TABLE
          • CREATE FUNCTION
          • CREATE REPOSITORY
          • CREATE SNAPSHOT
          • CREATE TABLE
          • CREATE TABLE AS
          • CREATE USER
          • CREATE VIEW
          • DEALLOCATE
          • DELETE
          • DENY
          • DISCARD
          • DROP ANALYZER
          • DROP FUNCTION
          • DROP REPOSITORY
          • DROP SNAPSHOT
          • DROP TABLE
          • DROP USER
          • DROP VIEW
          • EXPLAIN
          • GRANT
          • INSERT
          • KILL
          • OPTIMIZE
          • REFRESH
          • RESTORE SNAPSHOT
          • REVOKE
          • SELECT
          • SET and RESET
          • SET LICENSE
          • SET AND RESET SESSION AUTHORIZATION
          • SET TRANSACTION
          • SHOW COLUMNS
          • SHOW CREATE TABLE
          • SHOW SCHEMAS
          • SHOW TABLES
          • SHOW (session settings)
          • UPDATE
          • VALUES
      • Client interfaces
        • HTTP endpoint
        • PostgreSQL wire protocol
      • Appendices
        • Release Notes
          • Unreleased Changes
          • Version 4.6.1
          • Version 4.6.0
          • Version 4.5.4
          • Version 4.5.3
          • Version 4.5.2
          • Version 4.5.1
          • Version 4.5.0
          • Version 4.4.3
          • Version 4.4.2
          • Version 4.4.1
          • Version 4.4.0
          • Version 4.3.4
          • Version 4.3.3
          • Version 4.3.2
          • Version 4.3.1
          • Version 4.3.0
          • Version 4.2.7
          • Version 4.2.6
          • Version 4.2.5
          • Version 4.2.4
          • Version 4.2.3
          • Version 4.2.2
          • Version 4.2.1
          • Version 4.2.0
          • Version 4.1.8
          • Version 4.1.7
          • Version 4.1.6
          • Version 4.1.5
          • Version 4.1.4
          • Version 4.1.3
          • Version 4.1.2
          • Version 4.1.1
          • Version 4.1.0
          • Version 4.0.12
          • Version 4.0.11
          • Version 4.0.10
          • Version 4.0.9
          • Version 4.0.8
          • Version 4.0.7
          • Version 4.0.6
          • Version 4.0.5
          • Version 4.0.4
          • Version 4.0.3
          • Version 4.0.2
          • Version 4.0.1
          • Version 4.0.0
          • Version 3.3.6
          • Version 3.3.5
          • Version 3.3.4
          • Version 3.3.3
          • Version 3.3.2
          • Version 3.3.1
          • Version 3.3.0
          • Version 3.2.8
          • Version 3.2.7
          • Version 3.2.6
          • Version 3.2.5
          • Version 3.2.4
          • Version 3.2.3
          • Version 3.2.2
          • Version 3.2.1
          • Version 3.2.0
          • Version 3.1.6
          • Version 3.1.5
          • Version 3.1.4
          • Version 3.1.3
          • Version 3.1.2
          • Version 3.1.1
          • Version 3.1.0
          • Version 3.0.7
          • Version 3.0.6
          • Version 3.0.5
          • Version 3.0.4
          • Version 3.0.3
          • Version 3.0.2
          • Version 3.0.1
          • Version 3.0.0
          • Version 2.3.11
          • Version 2.3.10
          • Version 2.3.9
          • Version 2.3.8
          • Version 2.3.7
          • Version 2.3.6
          • Version 2.3.5
          • Version 2.3.4
          • Version 2.3.3
          • Version 2.3.2
          • Version 2.3.1
          • Version 2.3.0
          • Version 2.2.7
          • Version 2.2.6
          • Version 2.2.5
          • Version 2.2.4
          • Version 2.2.3
          • Version 2.2.2
          • Version 2.2.1
          • Version 2.2.0
          • Version 2.1.10
          • Version 2.1.9
          • Version 2.1.8
          • Version 2.1.7
          • Version 2.1.6
          • Version 2.1.5
          • Version 2.1.4
          • Version 2.1.3
          • Version 2.1.2
          • Version 2.1.1
          • Version 2.1.0
          • Version 2.0.7
          • Version 2.0.6
          • Version 2.0.5
          • Version 2.0.4
          • Version 2.0.3
          • Version 2.0.2
          • Version 2.0.1
          • Version 2.0.0
          • Version 1.2.0
          • Version 1.1.6
          • Version 1.1.5
          • Version 1.1.4
          • Version 1.1.3
          • Version 1.1.2
          • Version 1.1.1
          • Version 1.1.0
          • Version 1.0.6
          • Version 1.0.5
          • Version 1.0.4
          • Version 1.0.3
          • Version 1.0.2
          • Version 1.0.1
          • Version 1.0.0
        • SQL compatibility
        • SQL standard compliance
        • Resiliency Issues
        • Glossary
    暂无相关搜索结果！

      本文档使用 BookStack 构建

      展开/收起文章目录

      分享，让知识传承更久远

      文章二维码

      手机扫一扫，轻松掌上读

      文档下载

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

      微信小程序阅读

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

      书签列表

        阅读记录

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