Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
MySQL supports an additional, alternative syntax for this modifier, as shown in Section 15.2.13, “SELECT Statement”. The NULL values do appear as NULL on the client side and can be tested as such using any MySQL client programming interface. A ... The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
It is not possible to restrict the effects of these two variables to a single table; these variables control the behavior of all AUTO_INCREMENT columns in all tables on the MySQL server. If the global value of either variable is set, its effects ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group member. MySQL then checks each transaction against the ...You can create a user account with the appropriate privileges to apply the transactions that are normally replicated on a channel, and specify this as the PRIVILEGE_CHECKS_USER account for the replication applier, using a CHANGE REPLICATION SOURCE TO ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
The following list summarizes role-management capabilities provided by MySQL: CREATE ROLE and DROP ROLE create and remove roles. Unless otherwise specified, SQL statements shown here should be executed using a MySQL account with sufficient ...Like ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT CONCAT(2,' test'); -> '2 test' It is also possible to convert a number to a string explicitly using the CAST() ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-options-variables.html
Password Validation Plugin Options Note In MySQL 8.4, the validate_password plugin was reimplemented as the validate_password component. The validate_password plugin is deprecated; expect it to be removed in a future version of MySQL. MySQL ... This ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-summarize-content.html
Summarizing Content To summarize text, perform the following steps: To define the text that you want to summarize, set the @text variable: mysql> SET @text="TextToSummarize"; Replace TextToSummarize with the text that you want to summarize. For ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-model-import.html
ML_MODEL_IMPORT Overview MySQL AI supports the import of AutoML and Open Neural Network Exchange (ONNX) format models. Models in ONNX format (.onnx) cannot be loaded directly into a MySQL table. Use the ML_MODEL_IMPORT routine to import a ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-access.html
As for the destination MySQL server, you can have it in the same local machine or elsewhere in your network. Figure 10.22 Migration Overview Page Setting Up ODBC Drivers To verify that you have the ODBC driver installed, click Open ODBC ...General ...
https://dev.mysql.com/doc/workbench/en/wb-windows-uninstalling.html
The method for uninstalling MySQL Workbench depends on how you installed MySQL Workbench. Removing MySQL Workbench After Installation Using the Installer Package To uninstall MySQL Workbench, do one of the following: From Start, select Settings and ...For additional information about shared snippets, see Section 8.1.5, “SQL Additions - Snippets ...