Search Results
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
You can select a target MySQL Server release to which you plan to upgrade, ranging from the MySQL Server 8.0.11 up to the MySQL Server release number that matches the current MySQL Shell release number. To identify such tables, execute this query: ... Before upgrading to the latest MySQL 8.4 release, ensure the upgrade readiness of your current MySQL 8.3 or MySQL 8.4 server instance by performing the preliminary checks described ...
https://dev.mysql.com/doc/refman/8.4/en/view-syntax.html
A view can be created from many kinds of SELECT statements. The CREATE VIEW statement creates a new view (see Section 15.1.23, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.11, ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'authentication_webauthn'; +-------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | ... Note WebAuthn authentication is an ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-8.html
(WL #10620) X DevAPI: To support row locks for the find() method of the X DevAPI, the FindStatement and the SelecStatement interfaces have been extended with the following methods: lockExclusive(), which works like SELECT ... Version 8.0.8 ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-ml-model-metadata.html
selected_column_names: JSON array The names of the columns selected by feature selection. The model_metadata column in the model catalog allows you to view detailed information on trained models. For example, you can view the algorithm used to ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-privileges.html
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges.
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-nl-sql.html
The routine also runs the generated SQL statement and displays the result set. You can use this routine for generating and running SQL queries only for databases and tables that you have access to. The routine automatically detects these errors, and ...
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-management.html
Access these wizards from either the Navigator area of the sidebar, or by selecting Server from the main menu, and then either Data Import or Data Export. Select each schema you want to export, optionally choose specific schema objects/tables from ... Use this wizard to either export or import SQL generated from MySQL Workbench or with the mysqldump ...
https://dev.mysql.com/doc/workbench/en/wb-design-modeling-interface.html
Start MySQL Workbench and select the models view () from the side panel of the home screen tab. Click the arrow icon and select Create EER Model from Database as shown in the figure that follows. Figure 9.2 Create EER Model from Database A ... MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-help.html
Within the visual SQL Editor, you can select a keyword or function in your query to open a help topic describing its syntax and usage. Use the drop-down list to select a help topic for display. Most frequent keywords, when selected in the SQL ...