Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/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. row *************************** ...It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as part of the setting for the optimizer_switch server system ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/innodb-truncate-table-reclaim-space.html
Additionally, there cannot be a foreign key constraint between the table being truncated and other tables, otherwise the TRUNCATE TABLE operation fails. A foreign key constraint between two columns in the same table, however, is permitted. To ...
https://dev.mysql.com/doc/refman/8.4/en/join.html
index_hint: { USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) } index_list: index_name [, index_name] ... MySQL supports the following JOIN syntax for the ...
https://dev.mysql.com/doc/refman/8.4/en/multifactor-authentication.html
MFA enables additional authentication methods, such as authentication using multiple passwords, or authentication using devices like smart cards, security keys, and biometric readers. Something you have, such as a security key or smart card.