Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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: ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-character-sets-table.html
The CHARACTER_SETS table has these columns: CHARACTER_SET_NAME The character set name. MAXLEN The maximum number of bytes required to store one character. Notes Character set information is also available from the SHOW CHARACTER SET statement. The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-columns-table.html
For example, if you say SHOW FULL COLUMNS FROM t, and you see in the COLLATION_NAME column a value of utf8mb4_swedish_ci, the character set is what appears before the first underscore: utf8mb4. The related ST_GEOMETRY_COLUMNS table provides ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-events-table.html
COLLATION_CONNECTION The session value of the collation_connection system variable when the event was created. DATABASE_COLLATION The collation of the database with which the event is associated. The following statements are equivalent: SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-parameters-table.html
The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. The PARAMETERS table does not include built-in (native) functions or loadable ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-schemata-table.html
A schema is a database, so the SCHEMATA table provides information about databases. The SCHEMATA table has these columns: CATALOG_NAME The name of the catalog to which the schema belongs. The following statements are equivalent: SELECT SCHEMA_NAME ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-statistics-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-triggers-table.html
COLLATION_CONNECTION The session value of the collation_connection system variable when the trigger was created. DATABASE_COLLATION The collation of the database with which the trigger is associated. To see information about a table's triggers, you ...