| ROW_COUNT() | +-------------+ | 2 | +-------------+ 1 row in set (0.00 sec) 

## • SCHEMA() 

This function is a synonym for DATABASE() . 

## • SESSION_USER() 

SESSION_USER()  is a synonym for USER() . 

## • SYSTEM_USER() 

SYSTEM_USER()  is a synonym for USER() . 

## Important 

ROW_COUNT()  is not replicated reliably using statement-based replication. This function is automatically replicated using row-based replication. 

## Note 

The SYSTEM_USER()  function is distinct from the SYSTEM_USER  privilege. The former returns the current MySQL account name. The latter distinguishes the system user and regular user account categories (see Section 6.2.11, “Account Categories” ). 

## • USER() 

Returns the current MySQL user name and host name as a string in the utf8  character set. 

mysql> SELECT USER(); -> ’davida@localhost’ 

The value indicates the user name you specified when connecting to the server, and the client host from which you connected. The value can be different from that of CURRENT_USER() . 

## • VERSION() 

Returns a string that indicates the MySQL server version. The string uses the utf8  character set. The value might have a suffix in addition to the version number. See the description of the version  system variable in Section 5.1.8, “Server System Variables” . 

This function is unsafe for statement-based replication. A warning is logged if you use this function when binlog_format  is set to STATEMENT . 

## 12.17 Spatial Analysis Functions 

mysql> SELECT VERSION(); -> ’8.0.25-standard’ 

MySQL provides functions to perform various operations on spatial data. These functions can be grouped into several major categories according to the type of operation they perform: 

•Functions that create geometries in various formats (WKT, WKB, internal) 

•Functions that convert geometries between formats 

