Search Results
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code, such as 1051 to specify “unknown table”: DECLARE CONTINUE HANDLER FOR 1051 BEGIN -- body of handler END; Do not use MySQL error code 0 because ...statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ...
https://dev.mysql.com/doc/refman/8.4/en/expressions.html
The following table shows the expected form of the expr argument for each unit value. This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
Configuring group_replication_group_name tells the plugin that the group that it is joining, or creating, is named "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa". The host name that the server is using for SQL client connections can be verified in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-privilege-synchronization.html
A statement granting the NDB_STORED_USER privilege, such as GRANT NDB_STORED_USER ON *.* TO 'cluster_app_user'@'localhost', works by directing NDB to create a snapshot using the queries SHOW CREATE USER cluster_app_user@localhost and SHOW GRANTS FOR ... Privilege synchronization is the mechanism used by NDB Cluster for sharing and synchronizing users, roles, and privileges between SQL ...
https://dev.mysql.com/doc/workbench/en/wb-intro.html
Data Modeling (Design): Enables you to create models of your database schema graphically, reverse and forward engineer between a schema and a live database, and edit all aspects of your database using the comprehensive Table Editor. MySQL Workbench ... This chapter provides general information about MySQL Workbench and how it has ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-selection.html
If a partitioned table is accessed in a series of index lookups (that is, using the ref, eq_ref, or ref_or_null access methods), MySQL checks to see whether it needs to make index lookups in all partitions or that it can limit access to a ...If ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-json-functions.html
Table 5.7 JSON Functions Name Description -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). JSON_ARRAY() Create JSON array JSON_ARRAY_APPEND() Append data to JSON document JSON_ARRAY_INSERT() Insert into JSON ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-limitations.html
The model catalog schema created by the ML_TRAIN procedure incorporates the user name in the schema name (e.g., ML_SCHEMA_joesmith), and a period is not a permitted schema name character. Memory Limitations The table used to train a model cannot ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-handles.html
If you do not specify a model handle name, a model handle is automatically generated that is based on the database name, input table name, the user name training the table, and a unique numerical identifier. The following example queries the model ... When ML_TRAIN trains a model, you have the option to specify a name for the model, which is the model ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...