Search Results
https://dev.mysql.com/doc/refman/8.4/en/signal.html
To signal a generic SQLSTATE value, use '45000', which means “unhandled user-defined exception.” The SIGNAL statement optionally includes a SET clause that contains multiple signal items, in a list of condition_information_item_name = ...SIGNAL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-instruments-table.html
Instruments with a higher volatility index (for example, SESSION = 5) are created and destroyed for every user session. When an instrument is enabled and executed, instrumented instances are created, which are visible in the xxx_instances tables, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
The location of all undo tablespace files including user-defined undo tablespaces created using CREATE UNDO TABLESPACE syntax can be determined by querying the Information Schema FILES table: SELECT TABLESPACE_NAME, FILE_NAME FROM ...Default undo ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-connect.html
The user accounts created previously are used to connect to the server. Using the mysql client program, establish a connection for the user1@203.0.113.11 account that you created previously. The user1@203.0.113.11 account was created with the ...$> ...The first method uses the TLS (Transport Layer Security) protocol to establish an encrypted ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-training-an-anomaly-detection-model.html
mysql> SELECT model_id, model_handle, train_table_name FROM ML_SCHEMA_user1.MODEL_CATALOG WHERE model_handle = 'anomaly_detection_semi_supervised_use_case'; ...Unsupported Routines You cannot run the following routines for a trained anomaly ...
https://dev.mysql.com/doc/refman/8.4/en/installing-source-distribution.html
Then perform the following steps as the mysql user, except as noted. Create the directory and go there: $> mkdir bld $> cd bld Configure the build directory. To do this, starting with mysql-src as your current working directory, create the directory ... To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.8.2, “Source Installation ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-rpm.html
Notes The mysql user is created using the -r and -s /bin/false options of the useradd command, so that it does not have login permissions to your server host (see Creating the mysql User and Group for details). To switch to the mysql user on your ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-selective-load.html
This example creates the Object Storage folder data_files and uploads the files data_file_1.csv, data_file_2.csv, data_file_3.csv, data_file_4.csv, and data_file_5.csv. In the terminal window, create and use the database to store the table. mysql> ... Available as of MySQL 9.1.2, you can update external tables using Selective Load, which lets you edit the list of files that comprise an external table without altering the directories in the Object Storage ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-workspace-connect.html
Use the MySQL Administrator user specified when creating the DB System, see Creating a DB System, or use a MySQL user account created on the DB System using CREATE USER . Connecting from the Console 5.1 Connecting from the Console Connecting to a ...Use the Workspace page to connect to a DB System, and then manage MySQL HeatWave Cluster data and use the Query Editor to run DB System and MySQL HeatWave ...
https://dev.mysql.com/doc/refman/8.4/en/events-overview.html
Users can create, modify, and drop scheduled events using SQL statements intended for these purposes. The default definer of an event is the user who created the event, unless the event has been altered, in which case the definer is the user who ...