Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/mysql-cluster-ndbd-definition.html
An important point for both IndexMemory and DataMemory is that the total database size is the sum of all data memory and all index memory for each node group. Restart Type N When true, enable partial local checkpoints: This means that each LCP ...
https://dev.mysql.com/mysql-set-local-infile-handler.html
The arguments are the connection handler, a set of pointers to callback functions, and a pointer to a data area that the callbacks can use to share information. You can set the pointer (that is, *ptr) to a value that will be passed to each of the ...
https://dev.mysql.com/replication-options-master.html
The highest value present in the col column prior to the INSERT is 31, and the next available value in the AUTO_INCREMENT series is 35, so the inserted values for col begin at that point and the results are as shown for the SELECT query. This ...
https://dev.mysql.com/udf-aggr-calling.html
Declare xxx_clear() as follows: void xxx_clear(UDF_INIT *initid, char *is_null, char *error); is_null is set to point to CHAR(0) before calling xxx_clear(). If something went wrong, you can store a value in the variable to which the error argument ... This section describes the different functions that you need to define when you create an aggregate ...
https://dev.mysql.com/udf-calling.html
It points to a UDF_INIT structure that is used to communicate information between functions. unsigned int decimals The number of decimal digits to the right of the decimal point. A decimals value of 31 is used for arguments in cases such as a FLOAT ... This section describes the different functions that you need to define when you create a simple ...
https://dev.mysql.com/window-function-optimization.html
For example, adding a very small floating-point value to a very large value causes the very small value to be “hidden” by the large value. Loss of precision due to inverse aggregation is a factor only for operations on floating-point ... Window ...
https://dev.mysql.com/charset-unicode.html
BMP characters have these characteristics: Their code point values are between 0 and 65535 (or U+0000 and U+FFFF). Supplementary characters lie outside the BMP: Their code point values are between U+10000 and U+10FFFF). Although utf8 is currently an ... The Unicode Standard includes characters from the Basic Multilingual Plane (BMP) and supplementary characters that lie outside the ...
https://dev.mysql.com/create-index.html
If the typed array column is set to NULL, the storage engine stores single record containing NULL that points to the data record. The path need not point to an existing element in a JSON document inserted into the indexed column, but must itself be ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/create-table.html
AUTO_INCREMENT An integer or floating-point column can have the additional attribute AUTO_INCREMENT. (See Section 5.1.8, “Server System Variables”.) If you want all your tables to be able to grow above the default limit and are willing to have ... 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/data-type-defaults.html
Implicit defaults are defined as follows: For numeric types, the default is 0, with the exception that for integer or floating-point types declared with the AUTO_INCREMENT attribute, the default is the next value in the sequence. Data type ...
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-point-p-7.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.
