Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-supported-data-types.html
MySQL HeatWave AutoML has the following limitations for text usage: The ML_PREDICT_TABLE ml_results column contains the prediction results and the data. MySQL HeatWave AutoML does not support text columns with NULL values. MySQL HeatWave AutoML does ...What's Next Learn more about the following: Additional MySQL HeatWave AutoML Requirements MySQL HeatWave AutoML Privileges Learn how to Create a Machine Learning ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-25.html
For example, the following query can now be offloaded to MySQL HeatWave for execution: SELECT DISTINCT a FROM t1 ORDER BY c DESC; (Bug #32583856) Query plan statistics are now collected and stored in a statistics cache when a query is executed in ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-27-u2.html
The following columns were added to the performance_schema.rpd_tables table: SIZE_BYTES: The amount of data loaded per table, in bytes. The following column was added to the performance_schema.rpd_columns table: DICT_SIZE_BTYES: The dictionary size ... Functionality Added or Changed MySQL HeatWave now supports querying ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-28-u1.html
Functionality Added or Changed MySQL HeatWave now supports up to 1017 columns for base relations (tables as loaded into MySQL HeatWave), and up to 1800 columns for intermediate relations (intermediate tables used during query processing). The ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-bulk-ingesting.html
Specify the column and line terminators used by the in the data files you are loading. The statement above assumes the column terminator is \t and the line terminator is \n. The files are named, booking.tsv1, booking.tsv2, ..., booking.tsv25:LOAD ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-blob-clob-processing.html
For this to work, you must use a column alias with the value of the column to the actual name of the Blob. blobSendChunkSize Chunk size to use when sending BLOB/CLOBs via server-prepared statements. Note that this value cannot exceed the value of ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html
You must use a column alias with the value of the column to the actual name of the BLOB, for example: SELECT id, 'data' as blob_data from blobtable You must also follow these rules: The SELECT must reference only one table. The SELECT must alias the ... MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the publicly available version of Oracle's JDBC compliance test ...
https://dev.mysql.com/doc/connector-j/en/connector-j-YEAR.html
How a value in a MySQL YEAR column is handled is controlled by the connection property yearIsDateType: If yearIsDateType is true (the default), YEAR is mapped to the Java data type java.sql.Date. Connector/J handles the retrieval of zero values ...
https://dev.mysql.com/doc/refman/8.4/en/account-locking.html
Account locking state is recorded in the account_locked column of the mysql.user system table. The account-locking capability depends on the presence of the account_locked column in the mysql.user system table. For upgrades from MySQL versions older ... MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new ...
https://dev.mysql.com/doc/refman/8.4/en/account-names.html
MySQL stores account names in grant tables in the mysql system database using separate columns for the user name and host name parts: The user table contains one row for each account. The User and Host columns store the user name and host name.