Search Results
https://dev.mysql.com/doc/internals/en/packet-ERR_Packet.html
This packet signals that an error occurred. It contains a SQL state value if CLIENT_PROTOCOL_41 is enabled. Payload Type Name Description int<1> header [ff] header of the ERR packet int<2> error_code error-code if capabilities & CLIENT_PROTOCOL_41 ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-password-validation.html
The validate_password component serves to test user-specified passwords and improve security. The component exposes a set of system variables that enable you to define a password policy. The component implements two capabilities: In statements that ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-user-accounts.html
It demonstrates configuring global password policies, using security-related CREATE USER options, granting user privileges, and verifying user privileges and authentication. The user1 account is defined with an SSL/TLS option that requires an ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-syntax.html
Autopilot Indexing uses the following syntax: mysql> CALL sys.autopilot_index_advisor ([options]); options: { JSON_OBJECT('key','value'[,'key','value'] ...) 'key','value': ['output',{'normal'|'silent'|'help'}] ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-syntax.html
Produces summarized output and sends it to stdout and to the heatwave_autopilot_report table. The silent output type is useful if human-readable output is not required; when the output is consumed by a script, for example. If a target schema is not ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
MySQL 9.0.0 adds support for Lakehouse Incremental Load with the refresh_external_tables option, see: Section 4.3.13.2, “Refresh Data Using Incremental Load”. This adds an include list to exactly specify the tables and columns to load for a set ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload-syntax.html
This adds an include list to exactly specify the tables to unload, which eliminates the need to include a database and exclude unnecessary tables. mysql> CALL sys.HEATWAVE_UNLOAD_all ([options]); options: { JSON_OBJECT("key","value"[,"key","value"] ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-heatwave-chat.html
You can use MySQL HeatWave Chat to simulate human-like conversations where you can get responses for multiple queries in the same session. MySQL HeatWave Chat is a conversational agent that utilizes large language models (LLMs) to understand inputs ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-overview.html
MySQL HeatWave GenAI is a feature of MySQL HeatWave that lets you communicate with unstructured data in MySQL HeatWave using natural-language queries. It uses a familiar SQL interface which makes it is easy to use for content generation, ...
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(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...