Skip to Main Content
The world's most popular open source database
Contact MySQL
|
Login
|
Register
MySQL.com
Downloads
Documentation
Developer Zone
Developer Zone
Downloads
MySQL.com
Documentation
MySQL Server
MySQL Enterprise
Workbench
InnoDB Cluster
MySQL NDB Cluster
Connectors
More
MySQL.com
Downloads
Developer Zone
Section Menu:
Documentation Home
MySQL 8.0 Reference Manual
Preface and Legal Notices
General Information
Installing MySQL
Upgrading MySQL
Downgrading MySQL
Tutorial
MySQL Programs
MySQL Server Administration
Security
Backup and Recovery
Optimization
Language Structure
Character Sets, Collations, Unicode
Data Types
Functions and Operators
Built-In Function and Operator Reference
Loadable Function Reference
Type Conversion in Expression Evaluation
Operators
Operator Precedence
Comparison Functions and Operators
Logical Operators
Assignment Operators
Flow Control Functions
Numeric Functions and Operators
Arithmetic Operators
Mathematical Functions
Date and Time Functions
String Functions and Operators
String Comparison Functions and Operators
Regular Expressions
Character Set and Collation of Function Results
Full-Text Search Functions
Natural Language Full-Text Searches
Boolean Full-Text Searches
Full-Text Searches with Query Expansion
Full-Text Stopwords
Full-Text Restrictions
Fine-Tuning MySQL Full-Text Search
Adding a User-Defined Collation for Full-Text Indexing
ngram Full-Text Parser
MeCab Full-Text Parser Plugin
Cast Functions and Operators
XML Functions
Bit Functions and Operators
Encryption and Compression Functions
Locking Functions
Information Functions
Spatial Analysis Functions
Spatial Function Reference
Argument Handling by Spatial Functions
Functions That Create Geometry Values from WKT Values
Functions That Create Geometry Values from WKB Values
MySQL-Specific Functions That Create Geometry Values
Geometry Format Conversion Functions
Geometry Property Functions
General Geometry Property Functions
Point Property Functions
LineString and MultiLineString Property Functions
Polygon and MultiPolygon Property Functions
GeometryCollection Property Functions
Spatial Operator Functions
Functions That Test Spatial Relations Between Geometry Objects
Spatial Relation Functions That Use Object Shapes
Spatial Relation Functions That Use Minimum Bounding Rectangles
Spatial Geohash Functions
Spatial GeoJSON Functions
Spatial Aggregate Functions
Spatial Convenience Functions
JSON Functions
JSON Function Reference
Functions That Create JSON Values
Functions That Search JSON Values
Functions That Modify JSON Values
Functions That Return JSON Value Attributes
JSON Table Functions
JSON Schema Validation Functions
JSON Utility Functions
Replication Functions
Group Replication Functions
Function which Configures Group Replication Primary
Functions which Configure the Group Replication Mode
Functions to Inspect and Configure the Maximum Consensus Instances of a Group
Functions to Inspect and Set the Group Replication Communication Protocol Version
Functions to Set and Reset Group Replication Member Actions
Functions Used with Global Transaction Identifiers (GTIDs)
Asynchronous Replication Channel Failover Functions
Position-Based Synchronization Functions
Aggregate Functions
Aggregate Function Descriptions
GROUP BY Modifiers
MySQL Handling of GROUP BY
Detection of Functional Dependence
Window Functions
Window Function Descriptions
Window Function Concepts and Syntax
Window Function Frame Specification
Named Windows
Window Function Restrictions
Performance Schema Functions
Internal Functions
Miscellaneous Functions
Precision Math
Types of Numeric Values
DECIMAL Data Type Characteristics
Expression Handling
Rounding Behavior