Search Results
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Workaround: Consider using a non-string or non-BIT type column in the WHERE clause condition. Workaround: Use the BIT column in an expression or cast it to a different data type. Error number: 1026; Symbol: HW_ER_UNSUPPORTED_AGG_OVER_ENUM Message: ... The following list contains all current MySQL HeatWave errors in numerical ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-train.html
The table cannot exceed 10 GB, 100 million rows, or 1017 columns. target_column_name: The name of the target column containing ground truth values. If training an unsupervised Anomaly detection model (unlabeled data), set target_column_name to NULL.
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-train.html
The table cannot exceed 10 GB, 100 million rows, or 1017 columns. target_column_name: The name of the target column containing ground truth values. If training an unsupervised Anomaly detection model (unlabeled data), set target_column_name to NULL.
https://dev.mysql.com/doc/refman/8.4/en/grant.html
Database, table, column, and routine names can be up to 64 characters. Object Quoting Guidelines Several objects within GRANT statements are subject to quoting, although quoting is optional in many cases: Account, role, database, table, column, and ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
An event is not migrated or dropped as a result of renaming or dropping the user who created it. The same would be true if root had issued either of these statements: DROP USER jon@ghidora; RENAME USER jon@ghidora TO someotherguy@ghidora; You can ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
This option can be combined with other ALTER TABLE options such as those used to add, drop, or rename columns or indexes. This includes the rules governing the relationship between any unique keys (including any primary key) that the table might ...
https://dev.mysql.com/doc/workbench/en/wb-configuring-files.html
Table 3.2 Local MySQL Workbench Files and Directory Descriptions Directory or File Description cache/ General behaviors are stored per-connection in *.cache files, and column widths as *.column_widths files. The types of cache files are: ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
Use of CHANGE col_name, DROP col_name, or DROP INDEX, IGNORE or RENAME in ALTER TABLE statements. Use of index names, indexes on a prefix of a column, and use of INDEX or KEY in CREATE TABLE statements. You don't need to name all selected columns in ... MySQL Server supports some extensions that you are not likely to find in other SQL ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
If you have a user created sys schema, this must be renamed for the upgrade to succeed. To upgrade in this case, remove or rename the existing sys schema first. When Step 2 is upgrading the system tables in the mysql schema, the column order in the ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
This includes result data such as column values, result metadata such as column names, and error messages. For comparisons of strings with column values, collation_connection does not matter because columns have their own collation, which has a ...