Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/connection-attributes-xdevapi.html
Connection attributes are key-value pairs that application programs can pass to the server during connection time to be stored in the PERFORMANCE_SCHEMA tables session_account_connect_attrs and session_connect_attrs. There are two different kinds ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-indexing.html
This generic example (actual syntax might vary for different programming languages) shows how to create a mandatory integer type index based on the field count: myCollection.createIndex("count", {fields:[{"field": "$.count", "type":"INT", ... To ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/connection-attributes-xdevapi.html
Connection attributes are key-value pairs that application programs can pass to the server during connection time to be stored in the PERFORMANCE_SCHEMA tables session_account_connect_attrs and session_connect_attrs. There are two different kinds ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config.html
Spring is not only a system for configuring components, but also includes support for aspect oriented programming (AOP). For example, to configure a connection to a MySQL server supporting the world sample database, you might use: <util:map ... The ...
https://dev.mysql.com/doc/refman/8.4/en/assigning-passwords.html
Required credentials for clients that connect to the MySQL server can include a password. On some systems, your password becomes visible to system status programs such as ps that may be invoked by other users to display command lines. This is not ...MySQL stores credentials in the user table in the mysql system ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-restrictions.html
Only top-level statements are logged, not statements within stored programs such as triggers or stored procedures. The plugin must be installed on each MySQL server that is used to execute SQL on the cluster. Audit plugin data must be aggregated ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
Note In previous versions of MySQL, when evaluating an expression containing LEAST() or GREATEST(), the server attempted to guess the context in which the function was used, and to coerce the function's arguments to the data type of the expression ... Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.4/en/declare-condition.html
For a list of MySQL error codes, see Server Error Message Reference. For a list of SQLSTATE values, see Server Error Message Reference. Using names for conditions can help make stored program code clearer. DECLARE condition_name CONDITION FOR ...
https://dev.mysql.com/doc/refman/8.4/en/error-handling.html
This appendix describes the types of error information MySQL provides and how to obtain information about them. It describes common problems and errors that may occur and potential resolutions.
https://dev.mysql.com/doc/refman/8.4/en/identifier-length.html
For constraint definitions that include no constraint name, the server internally generates a name derived from the associated table name. The following table describes the maximum length for each type of identifier. For example, internally ...