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/extensions-to-ansi.html
For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the following statement, but other servers should not: SELECT /*! STRAIGHT_JOIN */ col1 FROM table1,table2 WHERE ... The KEY_BLOCK_SIZE clause in the following comment is executed ...
https://dev.mysql.com/doc/refman/8.0/en/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...
https://dev.mysql.com/doc/refman/8.0/en/gis-format-conversion-functions.html
The only permitted key value is axis-order, with permitted values of lat-long, long-lat and srid-defined (the default). MySQL supports the functions listed in this section for converting geometry values from internal geometry format to WKT or WKB ...
https://dev.mysql.com/doc/refman/8.0/en/gis-wkb-functions.html
The only permitted key value is axis-order, with permitted values of lat-long, long-lat and srid-defined (the default). These functions take as arguments a BLOB containing a Well-Known Binary (WKB) representation and, optionally, a spatial ...
https://dev.mysql.com/doc/refman/8.0/en/gis-wkt-functions.html
The only permitted key value is axis-order, with permitted values of lat-long, long-lat and srid-defined (the default). These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-ssl-for-recovery.html
group_replication_recovery_ssl_cert: The path name of the SSL public key certificate file to use for distributed recovery connections. group_replication_recovery_ssl_key: The path name of the SSL private key file to use for distributed recovery ...
https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1 filtered: 100.00 Extra: NULL *************************** 2. By default, MySQL (8.0.18 and ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-trx-table.html
TRX_FOREIGN_KEY_CHECKS Whether foreign key checks are turned on or off for the current transaction. TRX_LAST_FOREIGN_KEY_ERROR The detailed error message for the last foreign key error, if any; otherwise NULL. The INNODB_TRX table provides ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-intro.html
You can map multiple columns into the “value” part of the key-value store, with column values delimited by a user-specified separator character. For example, you can change the port that memcached listens on, reduce the maximum number of ... The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
For example, you might change the port that memcached listens on, reduce the maximum number of simultaneous connections, change the maximum memory size for a key-value pair, or enable debugging messages for the error log. When the table data is ...