Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-restrictions.html
In addition, these operators compare characters by their byte values and accented characters may not compare as equal even if a given collation treats them as equal. Identifiers are stored in mysql database tables (user, db, and so forth) using ...
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
Changes are sometimes made to character sets or collations that require table indexes to be rebuilt. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. CHECK TABLE can also check ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-check-constraints.html
CREATE TABLE permits the core features of table and column CHECK constraints, for all storage engines. CREATE TABLE permits the following CHECK constraint syntax, for both table constraints and column constraints: [CONSTRAINT [symbol]] CHECK (expr) ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
Retrained attributes are NULL (or NOT NULL) and, for those columns that have them, CHARACTER SET, COLLATION, COMMENT, and the DEFAULT clause. You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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 ...