General use

This section of the documentation covers any feature primarily of interest to a general user.

Table of contents

• 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
  • Inserting data
  • Updating data
  • Deleting data
  • Import and export
• Querying
  • Selecting data
  • Joins
  • Union
  • 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
  • CREATE OR REPLACE
  • Supported types
  • Overloading
  • Determinism
  • DROP FUNCTION
  • Supported languages
• Blobs
  • Creating a table for blobs
  • Custom location for storing blob data
  • List
  • Altering a blob table
  • Deleting a blob table
  • Using blob tables
• Optimistic Concurrency Control
  • Introduction
  • Optimistic update
  • Optimistic delete
  • Known limitations
• Information schema
  • Access
  • Virtual tables