Search Results
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-functions.html
There are three ways to add a new function to MySQL: Create a stored function (a type of stored object). A loadable function is compiled as a library file and then loaded and unloaded from the server dynamically using the CREATE FUNCTION and DROP ...A stored function is written using SQL statements rather than by compiling object ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-27.html
(Bug #28725534) Connector/J now supports authentication of MySQL users created using the authentication_oci plugin. (Bug #31117686) Synchronization in the MultiHostConnectionProxy#invoke() method forced connection pools to wait for statements to ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/command-line-integration-overview.html
As a result, if you connect to a MySQL Server which uses an option file, it will be used, by default, and attempt to create a global session using that configuration. This section provides an overview of the command-line integration and some basic ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-automl-privileges.html
mysql> GRANT CREATE, DROP, INSERT, SELECT, ALTER, DELETE, UPDATE ON database_name.* TO 'user_name'@'%'; Tracking and Monitoring Privileges You need the following privileges to track/monitor the status of AutoML and AutoML routines.. mysql> GRANT ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
This quickstart contains the following sections: tpch Requirements Generate tpch Sample Data Create the tpch Sample Database and Import Data Load tpch Data Into MySQL HeatWave Run tpch Queries Additional tpch Queries Unload tpch Tables tpch ... The ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-installation.html
This section describes how to install or uninstall MySQL Enterprise Data Masking and De-Identification, which is implemented as a plugin library file containing a plugin and several loadable functions. For general information about installing or ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-desc.html
Three of the table properties that can be set using NDB_TABLE comments embedded in CREATE TABLE and ALTER TABLE statements are also visible in ndb_desc output. You can check that the ALTER TABLE statement has the desired effect using SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-initialization.html
CREATE TABLE t1 ( ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, dt DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ); With a DEFAULT clause but no ON UPDATE CURRENT_TIMESTAMP clause, the column has the given ...
https://dev.mysql.com/doc/refman/8.4/en/windows-symbolic-links.html
To do this, create a symbolic link in the MySQL data directory that points to D:\data\mydb. However, before creating the symbolic link, make sure that the D:\data\mydb directory exists by creating it if necessary. On Windows, you can create a ... On ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-j2ee-concepts-connection-pooling.html
Connection pooling is a technique of creating and managing a pool of connections that are ready for use by any thread that needs them. Benefits of Connection Pooling The main benefits to connection pooling are: Reduced connection creation time.