Search Results
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. WEEK() Return the week number WEEKDAY() Return the weekday index WEEKOFYEAR() Return the calendar week of the date (1-53) ... The ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-metric-mysqlserver-ddlstatementactivity-category.html
Create Udf (Delta) The total number of CREATE FUNCTION statements executed for user defined functions. Create User (Delta) The total number of CREATE USER statements executed. Drop User (Delta) The total number of DROP USER statements executed.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-summary-tables.html
Summary tables provide aggregated information for terminated events over time. Tables that summarize events in similar ways often have similar sets of summary columns and differ only in the grouping columns used to determine how events are ...The ...
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. mysql> SELECT model_handle, model_owner, ...Model Handles Overview If you set the model handle name to a session variable before training a model, the model handle takes that ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-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. mysql> SELECT model_handle, model_owner, ...Model Handles Overview If you set the model handle name to a session variable before training a model, the model handle takes that ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
MySQL 8.4 supports an additional INTO option with EXPLAIN FORMAT=JSON, which enables saving the JSON formatted output into a user variable, like this: mysql> EXPLAIN FORMAT=JSON INTO @myselect -> SELECT name FROM a WHERE id = 2; Query OK, 0 rows ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-auto-parallel-load.html
Replace user_name and database_name in the commands with the appropriate user name and database name. mysql> GRANT PROCESS ON database_name.* TO 'user_name'@'%'; The EXECUTE privilege on the sys schema. mysql> GRANT SELECT ON performance_schema.* TO ...To use Auto Parallel Load, ask the admin user to grant you the following ... Auto Parallel Load is a feature of MySQL HeatWave that automates many of the steps for loading data, which ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-document-ids.html
// using a book's unique ISBN as the object ID myColl.add( { _id: "978-1449374020", title: "MySQL Cookbook: Solutions for Database Developers and Administrators" }).execute(); Use find() to fetch the newly inserted book from the collection by its ...
https://dev.mysql.com/doc/refman/8.4/en/windows-postinstallation.html
If you configured MySQL using MySQL Configurator, the root user is created automatically with the password you supplied. Before assigning a password, you might want to try running some client programs to make sure that you can connect to the server ... GUI tools exist that perform most of the tasks described in this section, including: MySQL Configurator: Used to configure the MySQL ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-installation-source-unix.html
Set the environment variable TEST_UID and perhaps also TEST_PASSWORD to the user name and password for the tests, if needed. By default, the tests use “root” as the user and do not enter a password; if you want the tests to use another user name ...See Character Sets, Collations, Unicode for more information on character set ...If you are using a character set that is not compiled into the MySQL client library, install the MySQL character definitions from the ...