Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/mysql-num-fields.html
unsigned int mysql_num_fields(MYSQL_RES *result) To pass a MYSQL* argument instead, use unsigned int mysql_field_count(MYSQL *mysql). An unsigned integer representing the number of columns in a result set. You can get the number of columns either ...
https://dev.mysql.com/control-flow-functions.html
Otherwise, the result is an integer type (with one exception): If all integer types are all signed or all unsigned, the result is the same sign and the precision is the highest of all specified integer types (that is, TINYINT, SMALLINT, MEDIUMINT, ...The second syntax returns the result for the first condition that is ...
https://dev.mysql.com/mysql-cluster-mgm-definition.html
Id Table 22.9 This table provides type and value information for the Id management node configuration parameter Property Value Version (or later) NDB 8.0.13 Type or units unsigned Default [none] Range 1 - 255 Restart Type IS Each node in the cluster ... The [ndb_mgmd] section is used to configure the behavior of the management ...
https://dev.mysql.com/mysql-cluster-tcp-definition.html
TCP_RCV_BUF_SIZE Table 22.301 This table provides type and value information for the TCP_RCV_BUF_SIZE TCP configuration parameter Property Value Version (or later) NDB 8.0.13 Type or units unsigned Default 0 Range 0 - 2G Restart Type N Determines ...
https://dev.mysql.com/mysql-field-count.html
unsigned int mysql_field_count(MYSQL *mysql) Returns the number of columns for the most recent query on the connection. An unsigned integer representing the number of columns in a result set. The normal use of this function is when ...
https://dev.mysql.com/mysql-set-local-infile-handler.html
void mysql_set_local_infile_handler(MYSQL *mysql, int (*local_infile_init)(void **, const char *, void *), int (*local_infile_read)(void *, char *, unsigned int), void (*local_infile_end)(void *), int (*local_infile_error)(void *, char*, unsigned ...It enables application programs to exert control over local (client-side) data file ...
https://dev.mysql.com/partitioning-pruning.html
The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be no matching values”. By limiting the search, it is possible to expend much less time and ...
https://dev.mysql.com/alter-table.html
To retain them, the statement must include them explicitly: ALTER TABLE t1 MODIFY col1 BIGINT UNSIGNED DEFAULT 1 COMMENT 'my column'; For data type changes using CHANGE or MODIFY, MySQL tries to convert existing column values to the new type as well ... ALTER TABLE tbl_name [alter_specification [, alter_specification] ...] [partition_options] alter_specification: table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX|KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/arithmetic-functions.html
If both operands are integers and any of them are unsigned, the result is an unsigned integer. For subtraction, if the NO_UNSIGNED_SUBTRACTION SQL mode is enabled, the result is signed even if any operand is unsigned. Table 12.11 Arithmetic ...
https://dev.mysql.com/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...
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-4.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.
