Search Results
https://dev.mysql.com/doc/refman/26.7/en/data-dictionary-information-schema.html
In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA table. When the underlying data dictionary tables store values ...
https://dev.mysql.com/doc/refman/26.7/en/data-masking-policy-usage.html
Dynamic data masking enables you to conditionally mask column data for specific users or roles. A masking policy is a rule, or set of rules, which determines how a column's data is transformed for access control. A masking policy consists of the ...
https://dev.mysql.com/doc/refman/26.7/en/date-and-time-functions.html
DATE_FORMAT() returns a string with a character set and collation given by character_set_connection and collation_connection so that it can return month and weekday names containing non-ASCII characters. This section describes the functions that ...
https://dev.mysql.com/doc/refman/26.7/en/engine-condition-pushdown-optimization.html
A string value to be compared with a column must use the same collation as the column. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to ...
https://dev.mysql.com/doc/refman/26.7/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...
https://dev.mysql.com/doc/refman/26.7/en/extensions-to-ansi.html
String comparisons are case-insensitive by default, with sort ordering determined by the collation of the current character set, which is utf8mb4 by default. MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs.
https://dev.mysql.com/doc/refman/26.7/en/faqs-mysql-cluster.html
This means that (for example) each Disk Data table record containing a VARCHAR(255) column requires space for 255 characters (as required for the character set and collation being used for the table), regardless of the actual number of characters ...
https://dev.mysql.com/doc/refman/26.7/en/fulltext-restrictions.html
Although the use of multiple character sets within a single table is supported, all columns in a FULLTEXT index must use the same character set and collation. Full-text searches are supported for InnoDB and MyISAM tables only. The exception is that ...
https://dev.mysql.com/doc/refman/26.7/en/glossary.html
Used for storing text-based documents, with associated character set and collation order. These terms are commonly used in information about the MySQL database server. Files with this extension are always included in backups produced by the ...
https://dev.mysql.com/doc/refman/26.7/en/group-replication-configuring-consistency-guarantees.html
Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: ...