Search Results
https://dev.mysql.com/doc/refman/8.4/en/char.html
For those cases where trailing pad characters are stripped or comparisons ignore them, if a column has an index that requires unique values, inserting into the column values that differ only in number of trailing pad characters results in a ... The ...
https://dev.mysql.com/doc/refman/8.4/en/charset-errors.html
This section describes how the MySQL server uses character sets for constructing error messages. For information about the language of error messages (rather than the character set), see Section 12.12, “Setting the Error Message Language”. For ...
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
Functional key parts (see Section 15.1.15, “CREATE INDEX Statement”) are implemented as hidden virtual generated stored columns, so each functional key part in a table index counts against the table total column limit. This section describes ...
https://dev.mysql.com/doc/refman/8.4/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...
https://dev.mysql.com/doc/refman/8.4/en/connecting.html
For information on establishing connections using URI-like connection strings or key-value pairs, for clients such as MySQL Shell, see Section 6.2.5, “Connecting to the Server Using URI-Like Strings or Key-Value Pairs”. This section describes ...
https://dev.mysql.com/doc/refman/8.4/en/data-directory.html
Information managed by the MySQL server is stored under a directory known as the data directory. The following list briefly describes the items typically found in the data directory, with cross references for additional information: Data directory ...
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
For InnoDB tables, the primary key columns are duplicated in each secondary index entry, so a short primary key saves considerable space if you have many secondary indexes. Design your tables to minimize their space on the disk. This can result in ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-literals.html
Standard SQL and ODBC Date and Time Literals Standard SQL requires temporal literals to be specified using a type keyword and a string. DATE 'str' TIME 'str' TIMESTAMP 'str' MySQL recognizes but, unlike standard SQL, does not require the type ...
https://dev.mysql.com/doc/refman/8.4/en/encrypted-connection-protocols-ciphers.html
The negotiation process depends on factors such as the SSL library used to compile the server and client, the TLS protocol and encryption cipher configuration, and which key size is used: For a connection attempt to succeed, the server and client ...
https://dev.mysql.com/doc/refman/8.4/en/end-markers-in-json-system-variable.html
When reading a very large JSON document, it can be difficult to pair its closing bracket and opening brackets; setting end_markers_in_json=ON repeats the structure's key, if it has one, near the closing bracket. Note If end_markers_in_json is ...