Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/string-type-overview.html
MySQL interprets length specifications in character column definitions in character units. Column definitions for character string data types CHAR, VARCHAR, the TEXT types, ENUM, SET, and any synonyms) can specify the column character set and ...For ...
https://dev.mysql.com/innodb-row-format.html
Tables that use the REDUNDANT row format store the first 768 bytes of variable-length column values (VARCHAR, VARBINARY, and BLOB and TEXT types) in the index record within the B-tree node, with the remainder stored on overflow pages. For example, a ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...
https://dev.mysql.com/create-table.html
Character data types (CHAR, VARCHAR, the TEXT types, ENUM, SET, and any synonyms) synonyms) can include CHARACTER SET to specify the character set for the column. A collation for the character set can be specified with the COLLATE attribute, along ... CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name (create_definition,...) [table_options] [partition_options] CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [partition_options] [IGNORE | REPLACE] [AS] query_expression CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name { LIKE old_tbl_name | (LIKE old_tbl_name) } create_definition: col_name column_definition | {INDEX|KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/keyring-service.html
The keyring service functions have these characteristics in common: Each function returns 0 for success, 1 for failure. Syntax: bool my_key_fetch(const char *key_id, const char **key_type, const char* user_id, void **key, size_t *key_len) Arguments: ... MySQL Server supports a keyring service that enables internal server components and plugins to securely store sensitive information for later ...
https://dev.mysql.com/writing-full-text-plugins.html
This plugin performs parsing based on simpler rules than those used by the MySQL built-in full-text parser: Words are nonempty runs of whitespace characters. cs: A pointer to information about the character set of the text, or 0 if no information is ... MySQL supports server-side full-text parser plugins with MyISAM and ...
https://dev.mysql.com/writing-keyring-plugins.html
MySQL Server supports a keyring service that enables internal server components and plugins to securely store sensitive information for later retrieval. This section describes how to write a server-side keyring plugin that can be used by service ...
https://dev.mysql.com/udf-calling.html
The initialization and deinitialization functions are declared like this: bool xxx_init(UDF_INIT *initid, UDF_ARGS *args, char *message); void xxx_deinit(UDF_INIT *initid); The initid parameter is passed to all three functions. (For numeric ... This ...
https://dev.mysql.com/c-api-data-structures.html
char * name The name of the field, as a null-terminated string. char * org_name The name of the field, as a null-terminated string. char * table The name of the table containing this field, if it is not a calculated field. char * org_table The name ... This section describes C API data structures other than those used for prepared statements, the asychronous interface, or the replication stream ...
https://dev.mysql.com/create-index.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/mysql-cluster-programs-ndb-import.html
--fields-enclosed-by=char Property Value Command-Line Format --fields-enclosed-by=char Type String Default Value [none] This works in the same way as the FIELDS ENCLOSED BY option does for the LOAD DATA statement, specifying a character to be ...
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-2.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.
