Search Results
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
Because MySQL does not check if a function really is deterministic at creation time, the invocation of a stored function with the DETERMINISTIC keyword might carry out an action that is unsafe for statement-based logging, or invoke a function or ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-apptips-microsoft.html
5.8.2.1.1 Microsoft Access To improve the integration between Microsoft Access and MySQL through Connector/ODBC: For all versions of Access, enable the Connector/ODBC Return matching rows option. Include a TIMESTAMP column in all tables that you ...
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
The existing tables within it are part of the general mysql tablespace, which may be encrypted. This option is useful for database migration because a database for which READ ONLY is enabled can be migrated to another MySQL instance without concern ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
It is now time to expand the group by adding the other two servers configured previously. [mysqld] # # Disable other storage engines # disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" # # Replication configuration parameters # ...
https://dev.mysql.com/doc/refman/8.4/en/json-table-functions.html
type is a MySQL scalar data type (that is, it cannot be an object or array). JSON_TABLE() extracts data as JSON then coerces it to the column type, using the regular automatic type conversion applying to JSON data in MySQL. type can be any valid ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-support-version-history.html
For example, when MySQL Server released versions 5.7.43, 8.0.34, and 8.1.0, this connector released connector version (8.1.0) that connects to all three MySQL Server versions. This is the first series without 32-bit support, which ended for all ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-support-version-history.html
For example, when MySQL Server released versions 5.7.43, 8.0.34, and 8.1.0, this connector released connector version (8.1.0) that connects to all three MySQL Server versions. This is the first series without 32-bit support, which ended for all ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-data-drift-detection.html
MySQL HeatWave AutoML includes data drift detection for the following models: Classification Regression Anomaly detection (as of MySQL 9.3.2) Before You Begin Review how to Create a Machine Learning Model. Over time, the similarity between the ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-component-installation.html
Note Only one keyring component or plugin should be enabled at a time. MySQL provides these keyring component choices: component_keyring_file: Stores keyring data in a file local to the server host. To be usable by the server, the component library ... Keyring service consumers require that a keyring component or plugin be installed: To use a keyring component, begin with the instructions ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
On Unix, make sure that they are readable by the user that mysqld runs as (and to you, because you need to access the files you are checking). If you are going to repair a table from the command line, you must first stop the mysqld server. Note that ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...