Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-reload-tables.html
mysql> CALL sys.HEATWAVE_RELOAD([options]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) "key","value": { ["only_user_loaded_tables",{true|false}] ["output",{"normal"|"silent"}] } } Use key-value pairs in JSON format to specify options.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
https://dev.mysql.com/doc/refman/8.4/en/events-overview.html
An event can be modified by any user having the EVENT privilege on the database for which the event is defined. Users can create, modify, and drop scheduled events using SQL statements intended for these purposes. While there is no provision in the ...When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-run-chat.html
**Model Training**: The platform trains the selected model on the user's dataset and provides real-time feedback and guidance throughout the process. **Automated Model Selection**: HeatWave AutoML allows users to select the best-performing model for ...If you do not have a vector store or an embedding table set up, then GenAI Chat uses information available in public data sources to generate a response for your ...By default, GenAI Chat ...
https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html
$> MYSQL -u userx -p ERROR 1045 (28000): Access denied for user 'userx'@'localhost' (using password: NO) The server writes these errors to the server log. mysql> CREATE USER userxx@localhost IDENTIFIED WITH 'mysql_native_password'; ERROR 1524 ...The ...
https://dev.mysql.com/doc/internals/en/guided-tour-skeleton.html
The first thing to do is check whether the user has the appropriate privileges for doing an INSERT into the table, and this is the place where the server checks for that, by calling the check_access and check_grant functions. The first fields of a ...There will be — we're going into list mode now and just reciting the rest of the items in the switch statement — code for prepare, close statement, query, quit, create database, drop database, dump binary log, refresh, statistics, get process info, kill process, sleep, connect, and several minor ...
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/innodb-data-encryption.html
A DBA can grant this privilege to enable a user to deviate from the default_table_encryption setting when creating or altering a schema or general tablespace, or to deviate from the default schema encryption when creating or altering a table. You ...
https://dev.mysql.com/doc/refman/8.4/en/preface.html
If you are using a Commercial release of MySQL 8.4, see the MySQL 8.4 Commercial Release License Information User Manual for licensing information, including licensing information relating to third-party software that may be included in this ...This ...If you are using an earlier release of the MySQL software, please refer to the appropriate ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-json-mysqlsh.html
With the mysqlsh command interface, you invoke the JSON import utility as follows: mysqlsh user@host:port/mydb -- util importJson <path> [options] or mysqlsh user@host:port/mydb -- util import-json <path> [options] For information on this syntax, ...port The port number for MySQL Shell's connection to the MySQL ...You can either specify it in the URI-like ...