General use

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

• 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 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
• 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