Search Results
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-20.html
It was because Connector/J always converted a Date value to the server's time zone when storing it on the server as a MySQL DATE; but since a MySQL DATE does not have any time value, the hour, minute, and second parts of the original date was ...(WL ... Version 8.0.20 is the latest General Availability release of the 8.0 series of MySQL ...
https://dev.mysql.com/doc/internals/en/implementing-records-in-range-method.html
The [custom-engine.html#custom-engine-api-reference-records_in_range records_in_range()] method is called by the optimizer to assist in choosing which index on a table to use for a query or join. It is defined as follows: ha_rows ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-cloning.html
Group Replication calculates whether the threshold has been exceeded based on the gtid_executed sets of the existing group members. To ensure the maximum availability of donors, it is advisable to set up all current and future group members to ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-loading-unloading-heatwave.html
If a load operation fails, the error message contains a View Details link that opens the Load operation summary pane, which contains the following information: The failed query that was executed for the load operation. The time required to load data ... Loading or Unloading Data into MySQL HeatWave Cluster 9.1 Loading or Unloading Data into MySQL HeatWave Cluster Use MySQL HeatWave Console to load data into or unload data from a MySQL HeatWave ...
https://dev.mysql.com/doc/refman/8.4/en/blob.html
If strict SQL mode is not enabled and you assign a value to a BLOB or TEXT column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. These differ only in the maximum length of the values they can hold. These correspond to the four BLOB types and have the same maximum lengths and storage ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
The maximum number of tables that can be referenced in the definition of a view is 61. In this case, the view is stored in a temporary table and thus you are not really selecting from the table in a subquery and modifying it at the same time. View ...
https://dev.mysql.com/doc/refman/8.4/en/out-of-range-and-overflow.html
When a floating-point or fixed-point column is assigned a value that exceeds the range implied by the specified (or default) precision and scale, MySQL stores the value representing the corresponding endpoint of that range. If strict SQL mode is ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/schema-advisor-ref.html
If you try to generate a number that exceeds the maximum allowed by the underlying data type, such as by inserting a NULL value into the AUTO_INCREMENT column, database errors are triggered and your application may not behave properly. For example, ...MySQL's mechanism for doing this is the AUTO_INCREMENT column attribute, which enables you to generate sequential numbers ...
https://dev.mysql.com/doc/connectors/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...
https://dev.mysql.com/doc/connector-j/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...