Search Results
https://dev.mysql.com/doc/internals/en/optimizer-nulls-filtering.html
This section discusses the NULLs filtering optimization used for ref and eq_ref joins.
https://dev.mysql.com/doc/c-api/8.4/en/null-mysql-store-result.html
It is possible for mysql_store_result() to return NULL following a successful call to the server using mysql_real_query() or mysql_query(). When this happens, it means one of the following conditions occurred: There was a malloc() failure (for ...
https://dev.mysql.com/doc/workbench/en/wb-model-reporting.html
The DBDoc - Model Reporting dialog is found by opening a model, selecting Model from the menu, and then DBDoc - Model Reporting. Note This functionality is only available in the MySQL Workbench Commercial Editions. Use the DBDoc- Model Reporting ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-recattr-vs-ndbrecord.html
This example illustrates the key differences between the old-style NdbRecAttr API and the newer approach using NdbRecord when performing some common tasks in an NDB API application. The source code can be found can be found in the file ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html
This section describes the functions that can be used to manipulate temporal values. See Section 13.2, “Date and Time Data Types”, for a description of the range of values each date and time type has and the valid formats in which values may be ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
For functions that operate on string positions, the first position is numbered 1. For functions that take length arguments, noninteger arguments are rounded to the nearest integer. ASCII(str) Returns the numeric value of the leftmost character of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
The tpch Analytics Quickstart shows how to import data into the DB System using the MySQL Shell Parallel Table Import Utility, manually loading data into MySQL HeatWave Cluster, and running queries. This quickstart contains the following sections: ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
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 operations. ROLLUP thus enables you to answer questions at multiple levels of ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or disabled. This variable has global and session values and can be changed at runtime. To see the current set of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
This topic describes how to debug queries that fail to offload to MySQL HeatWave for execution. To learn how to download the sample database, see AirportDB Analytics Quickstart. Setting Secondary Engine Definition By default, SELECT queries are ...