Search Results
https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
When the derived table has a GROUP BY and uses no window functions, an outer WHERE condition referencing one or more columns which are not part of the GROUP BY can be pushed down to the derived table as a HAVING condition. When the derived table ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-restrictions.html
Although FULLTEXT indexes on ucs2 columns cannot be used, you can perform IN BOOLEAN MODE searches on a ucs2 column that has no such index. Although the use of multiple character sets within a single table is supported, all columns in a FULLTEXT ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 28.2 INFORMATION_SCHEMA General Tables Table Name Description ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable users or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
When to Use Compression In general, compression works best on tables that include a reasonable number of character string columns and where the data is read far more often than it is written. Character strings often compress well, whether defined in ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/8.4/en/option-modifiers.html
For example, the mysql client supports a --column-names option that determines whether or not to display a row of column names at the beginning of query results. To disable column names, you can specify the option using any of these forms: ... Some ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
The prepared_statements_instances table has these columns: OBJECT_INSTANCE_BEGIN The address in memory of the instrumented prepared statement. For the text protocol, this column is the external statement name assigned by the user. OWNER_THREAD_ID, ... The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
For example, you can use SELECT as a simple calculator to evaluate expressions that make no reference to tables: SELECT 1+1; SELECT PI()*2; The SELECT privilege is also needed for other statements that read column values. For example, SELECT is ...
https://dev.mysql.com/doc/refman/8.4/en/table.html
TABLE is a DML statement which returns rows and columns of the named table. For limiting which table columns are returned, filtering rows beyond what can be accomplished using ORDER BY and LIMIT, or both, use SELECT. Given the existence of a table ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-call-statements.html
The number of columns and the data types of the columns need not be the same for all result sets. This section describes prepared-statement support in the C API for stored procedures executed using CALL statements: Stored procedures executed using ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-bind-result.html
bool mysql_stmt_bind_result(MYSQL_STMT *stmt, MYSQL_BIND *bind) Description mysql_stmt_bind_result() is used to associate (that is, bind) output columns in the result set to data buffers and length buffers. When mysql_stmt_fetch() is called to ...