PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/row-constructor-optimization.html
However, the row constructor itself does not cover an index prefix, with the result that the optimizer uses only c1 (key_len=4, the size of c1): mysql> EXPLAIN SELECT * FROM t1 WHERE c1=1 AND (c2,c3) > (1,1)\G *************************** 1. For ...
https://dev.mysql.com/doc/refman/8.0/en/set-transaction.html
transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE } access_mode: { READ WRITE | READ ONLY } This statement specifies transaction characteristics. It takes ...
https://dev.mysql.com/doc/refman/8.0/en/show-collation.html
SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By default, the output from SHOW COLLATION includes all available collations. The LIKE clause, if present, indicates which collation names to ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-database.html
row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80014 DEFAULT ENCRYPTION='N' */ mysql> SHOW CREATE SCHEMA test\G ... SHOW CREATE {DATABASE ...
https://dev.mysql.com/doc/refman/8.0/en/show-databases.html
SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr] SHOW DATABASES lists the databases on the MySQL server host. MySQL implements databases as directories in the data directory, so this statement simply lists directories in that location. The ...
https://dev.mysql.com/doc/refman/8.0/en/show-privileges.html
SHOW PRIVILEGES SHOW PRIVILEGES shows the list of system privileges that the MySQL server supports. The privileges displayed include all static privileges, and all currently registered dynamic privileges. row *************************** Privilege: ...
https://dev.mysql.com/doc/refman/8.0/en/shutdown.html
SHUTDOWN provides an SQL-level interface to the same functionality available using the mysqladmin shutdown command or the mysql_shutdown() C API function. A successful SHUTDOWN sequence consists of checking the privileges, validating the arguments, ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-analysis-functions.html
MySQL provides functions to perform various operations on spatial data.
https://dev.mysql.com/doc/refman/8.0/en/spatial-function-argument-handling.html
In MySQL, the SRID value is an integer associated with the geometry value. In MySQL, the only valid empty geometry is represented in the form of an empty geometry collection. Spatial values, or geometries, have the properties described in Section ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. For other examples showing how to use spatial data types in MySQL, see Section 13.4.6, “Creating Spatial Columns”. The basis for these types is described in Section 13.4.2, “The ...