Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/integer-types.html
As an extension to the standard, MySQL also supports the integer types TINYINT, MEDIUMINT, and BIGINT. MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. The following table shows the required storage and range for each ...
https://dev.mysql.com/bit-functions.html
(The BIT_AND(), BIT_OR(), and BIT_XOR() aggregate functions are described in Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”.) Prior to MySQL 8.0, bit functions and operators required BIGINT (64-bit integer) arguments and returned ...In MySQL 8.0, bit functions and operators permit binary string type arguments (BINARY, VARBINARY, and the BLOB types) and return a value of like type, which enables them to take arguments and produce return values larger than 64 ...
https://dev.mysql.com/numeric-type-overview.html
SERIAL is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE. SERIAL is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE. MySQL can handle BIGINT in the following cases: When using integers to store large unsigned values in a ...
https://dev.mysql.com/mysql-cluster-replication-conflict-resolution.html
However, the data type of this column is never TIMESTAMP; instead, its data type should be INT (INTEGER) or BIGINT. This column should be defined as follows: NDB$ORIG_TRANSID BIGINT UNSIGNED NOT NULL NDB$ORIG_TRANSID is a 64-bit value generated by ... When using a replication setup involving multiple masters (including circular replication), it is possible that different masters may try to update the same row on the slave with different ...
https://dev.mysql.com/arithmetic-functions.html
The result is determined according to the following rules: In the case of -, +, and *, the result is calculated with BIGINT (64-bit) precision if both operands are integers. mysql> SELECT - 2; -> -2 Note If this operator is used with a BIGINT, the ... Table 12.11 Arithmetic Operators Name Description DIV Integer division / Division operator - Minus operator %, MOD Modulo operator + Addition operator * Multiplication operator - Change the sign of the argument The usual arithmetic operators are ...
https://dev.mysql.com/mysql-cluster-replication-schema.html
Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated and the replication slave (whether the slave is a single server or a ...
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/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/group-by-functions.html
Prior to MySQL 8.0, bit functions and operators required BIGINT (64-bit integer) arguments and returned BIGINT values, so they had a maximum range of 64 bits. Non-BIGINT arguments were converted to BIGINT prior to performing the operation and ...
https://dev.mysql.com/mysql-cluster-online-add-node-example.html
In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node groups.
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-bigint-p-1.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.
