No cache version.
Caching disabled. Default setting for this page:enabled (code DEF204)
If the display is too slow, you can disable the user mode to view the cached version.
Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/group-by-functions.html
Numeric evaluation occurs otherwise, with argument value conversion to unsigned 64-bit integers as necessary. Numeric evaluation occurs otherwise, with argument value conversion to unsigned 64-bit integers as necessary. Numeric evaluation occurs ...
https://dev.mysql.com/replication-features-differing-tables.html
ALL_SIGNED,ALL_UNSIGNED Treat promoted integer types as signed if possible, otherwise as unsigned. ALL_SIGNED tells the slave to treat all promoted integer types as signed; ALL_UNSIGNED instructs it to treat these as unsigned. Specifying both causes ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/mysql-cluster-programs-ndb-config.html
Deprecated parameters are indicated in the XML output by the deprecated attribute, as shown here: <param name="NoOfDiskPagesToDiskAfterRestartACC" comment="DiskCheckpointSpeed" type="unsigned" default="20" min="1" max="4294967039" ... This tool ...
https://dev.mysql.com/mysql-cluster-sci-definition.html
Host1SciId0 Table 22.322 This table provides type and value information for the Host1SciId0 SCI configuration parameter Property Value Version (or later) NDB 8.0.13 Type or units unsigned Default [none] Range 0 - 4294967039 (0xFFFFFEFF) Restart Type ... [sci] sections in the config.ini file explicitly define SCI (Scalable Coherent Interface) connections between cluster ...
https://dev.mysql.com/mysql-real-escape-string.html
unsigned long mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned long length) This function creates a legal SQL string for use in an SQL statement. Because mysql_real_escape_string() returns an unsigned value, you can check ...Note mysql_real_escape_string() fails and produces an CR_INSECURE_API_ERR error if the NO_BACKSLASH_ESCAPES SQL mode is ...
https://dev.mysql.com/mysql-stmt-attr-set.html
STMT_ATTR_CURSOR_TYPE unsigned long * Type of cursor to open for statement when mysql_stmt_execute() is invoked. STMT_ATTR_PREFETCH_ROWS unsigned long * Number of rows to fetch from server at a time when using a cursor. *arg can be in the range from ... bool mysql_stmt_attr_set(MYSQL_STMT *stmt, enum enum_stmt_attr_type option, const void *arg) Can be used to affect behavior for a prepared ...
https://dev.mysql.com/numeric-type-attributes.html
An unsigned type can be used to permit only nonnegative numbers in a column or when you need a larger upper numeric range for the column. For example, if an INT column is UNSIGNED, the size of the column's range is the same but its endpoints shift ... MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the ...
https://dev.mysql.com/example-foreign-keys.html
In MySQL, InnoDB tables support checking of foreign key constraints. See Chapter 15, The InnoDB Storage Engine, and Section 1.8.2.3, “Foreign Key Differences”. A foreign key constraint is not required merely to join two tables. It is extremely ...
https://dev.mysql.com/innodb-fulltext-index.html
If you want to create your own FTS_DOC_ID column, the column must be defined as BIGINT UNSIGNED NOT NULL and named FTS_DOC_ID (all upper case), as in the following example: Note The FTS_DOC_ID column does not need to be defined as an AUTO_INCREMENT ... FULLTEXT indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to help speed up queries and DML operations on data contained within those columns, omitting any words that are defined as ...
https://dev.mysql.com/mysql-fetch-lengths.html
unsigned long *mysql_fetch_lengths(MYSQL_RES *result) Returns the lengths of the columns of the current row within a result set. An array of unsigned long integers representing the size of each column (not including any terminating null bytes). If ...
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-unsigned-p-3.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.
