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