MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 8 total results

2.8.7 MySQL Source-Configuration Options

https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html

For boolean options, the value may be specified as 1 or ON to enable the option, or as 0 or OFF to disable the option. -DWITH_BUILD_ID=bool On Linux systems, generates a unique build ID which is used as the value of the build_id system variable and ... The CMake program provides a great deal of control over how you configure a MySQL source ...

10.2.1.8 Nested Join Optimization

https://dev.mysql.com/doc/refman/8.0/en/nested-join-optimization.html

The following discussion refers to the join syntax described in Section 15.2.13.2, “JOIN Clause”. The syntax of table_factor is extended in comparison with the SQL Standard. The latter accepts only table_reference, not a list of them inside a ...

7.6.9.2 The Keyring Service

https://dev.mysql.com/doc/refman/8.0/en/keyring-service.html

Syntax: bool my_key_fetch(const char *key_id, const char **key_type, const char* user_id, void **key, size_t *key_len) Arguments: key_id, user_id: Null-terminated strings that as a pair form a unique identifier indicating which key to fetch. Syntax: ... MySQL Server supports a keyring service that enables internal components and plugins to securely store sensitive information for later ...

25.5.7 ndb_config — Extract NDB Cluster Configuration Information

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-config.html

This tool extracts current configuration information for data nodes, SQL nodes, and API nodes from one of a number of sources: an NDB Cluster management node, or its config.ini or my.cnf file. By default, the management node is the source for the ...

13.9 Using Data Types from Other Database Engines

https://dev.mysql.com/doc/refman/8.0/en/other-vendor-data-types.html

To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...

8.2.16 Server Handling of Expired Passwords

https://dev.mysql.com/doc/refman/8.0/en/expired-password-handling.html

For clients that use the C client library, there are two ways to do this: Pass the MYSQL_OPT_CAN_HANDLE_EXPIRED_PASSWORDS flag to mysql_options() prior to connecting: bool arg = 1; mysql_options(mysql, MYSQL_OPT_CAN_HANDLE_EXPIRED_PASSWORDS, &arg); ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...

11.3 Keywords and Reserved Words

https://dev.mysql.com/doc/refman/8.0/en/keywords.html

Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...

13.1.1 Numeric Data Type Syntax

https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html

For integer data types, M indicates the minimum display width. Display width is unrelated to the range of values a type can store, as described in Section 13.1.6, “Numeric Type Attributes”. For floating-point and fixed-point data types, M is ...