Search Results
https://dev.mysql.com/doc/refman/8.4/en/federated-create-connection.html
To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) ...In the example, the remote table is on the server remote_host, using port ...
https://dev.mysql.com/doc/refman/8.4/en/json-validation-functions.html
Both functions handle null or invalid input as follows: If at least one of the arguments is NULL, the function returns NULL. As before, you can see this by attempting to insert the value into the geo table, then issuing SHOW WARNINGS afterwards: ...
https://dev.mysql.com/doc/refman/8.4/en/set.html
A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is created. For example, a column specified as SET('one', 'two') NOT NULL can have any of these ...SET ...
https://dev.mysql.com/doc/internals/en/com-binlog-dump-gtid.html
If the binlog-filename is empty, the server will send the binlog-stream of the first known binlog.
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-14.html
(Bug #28962337, WL #12240) Attempting to connect to a default schema with insufficient privileges would yield a "does not exist" error instead of "access denied." (Bug #28942938) Improved error handling for connection strings that contain invalid ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-parameters-table.html
The PARAMETER_NAME and PARAMETER_MODE values are NULL because the return value has no name and the mode does not apply. The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and ...
https://dev.mysql.com/doc/workbench/en/wb-data-modeling-menus.html
Figure 9.4 The Find Panel with Find & Replace Find Options The Find dialog options are described in the following list: String Matching (default) or Regular Expression: Search by matching a string, or a PCRE regular expression. Works with both the ... Some menu items are not available in the MySQL Workbench Community Edition of this application, and are available only in the MySQL Workbench Commercial ...
https://dev.mysql.com/doc/connectors/en/connecting-using-kerberos.html
Kerberos Authentication Workflow The main usage of Kerberos authentication in MySQL is to allow users to create connections without having to specify a user name and password in the connection string. A user name specified in the connection string ... Kerberos is a ticket-based server-client mutual authentication protocol that is supported by the MySQL Server (commercial versions only) ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-26.html
without the use of workarounds such as specially formatted comments included in query strings. This capability is implemented using type-specific methods for the sql::Statement class: int Statement::setQueryAttrInt(attr_name, int_value); int ...
https://dev.mysql.com/doc/connector-j/en/connecting-using-kerberos.html
Kerberos Authentication Workflow The main usage of Kerberos authentication in MySQL is to allow users to create connections without having to specify a user name and password in the connection string. A user name specified in the connection string ... Kerberos is a ticket-based server-client mutual authentication protocol that is supported by the MySQL Server (commercial versions only) ...