Rechercher dans le manuel MySQL
Search Results
Displaying 181 to 190
of 196 total results
- « Previous
- 17
- 18
- 19
- 20
- Next »
https://dev.mysql.com/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/plugin-services.html
It complements the plugin API and has these characteristics: Services enable plugins to access code inside the server using ordinary function calls. mysql/service_my_plugin_log.h defines these levels: enum plugin_log_level { MY_ERROR_LEVEL, ...
https://dev.mysql.com/plugin-types.html
MySQL also has a character-based ngram full-text parser that supports Chinese, Japanese, and Korean (CJK), and a word-based MeCab parser plugin that supports Japanese, for use with InnoDB and MyISAM tables. For full-text processing, “parsing” ...
https://dev.mysql.com/replication-gtids-concepts.html
A GTID is represented as a pair of coordinates, separated by a colon character (:), as shown here: GTID = source_id:transaction_id The source_id identifies the originating server. A global transaction identifier (GTID) is a unique identifier ...
https://dev.mysql.com/row-constructor-optimization.html
Consider the following table, which has a primary key on (c1, c2, c3): CREATE TABLE t1 ( c1 INT, c2 INT, c3 INT, c4 CHAR(100), PRIMARY KEY(c1,c2,c3) ); In this query, the WHERE clause uses all columns in the index. For example, these two statements ...
https://dev.mysql.com/show-create-table.html
row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int(11) NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 As of MySQL 8.0.16, MySQL implements CHECK ... SHOW ...
https://dev.mysql.com/show-index.html
That is, the number of indexed characters if the column is only partly indexed, NULL if the entire column is indexed. However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as ...
https://dev.mysql.com/silent-column-changes.html
If strict SQL mode is not enabled, a VARCHAR column with a length specification greater than 65535 is converted to TEXT, and a VARBINARY column with a length specification greater than 65535 is converted to BLOB. Specifying the CHARACTER SET binary ... In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE ...
https://dev.mysql.com/static-format.html
It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Static-format tables have these characteristics: CHAR and VARCHAR columns are space-padded to the specified column width, although the column type is ...Of the three MyISAM storage formats, static format is the simplest and most secure (least subject to ...
https://dev.mysql.com/statistics-table.html
That is, the number of indexed characters if the column is only partly indexed, NULL if the entire column is indexed. However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as ...
Displaying 181 to 190
of 196 total results
- « Previous
- 17
- 18
- 19
- 20
- Next »
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-char-p-19.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
