PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-auto-increment-handling.html
If the AUTO_INCREMENT value becomes larger than the maximum integer for the specified integer type In all lock modes (0, 1, and 2), the behavior of the auto-increment mechanism is undefined if the value becomes larger than the maximum integer that ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-redo-log-reader.html
# is an integer in the range 0 to 15, inclusive. Command-Line Format -page # Type Integer Default Value 0 Minimum Value 0 Maximum Value 31 -page #: Start at this page. # is an integer in the range 0 to 31, inclusive. Command-Line Format -pageindex # ... Reads a redo log file, checking it for errors, printing its contents in a human-readable format, or ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-show-tables.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/9.7/en/number-literals.html
Number literals include exact-value (integer and DECIMAL) literals and approximate-value (floating-point) literals. Exact-value numeric literals have an integer part or fractional part, or both. An integer may be used in floating-point context; it ...Numbers may be preceded by - or + to indicate a negative or positive value, ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-hash.html
To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH (expr) clause, where expr is an expression that returns an integer. This can simply be the name of a column whose type is one ... Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-expressions.html
In strict SQL mode, for INSERT into a column with an exact data type (DECIMAL or integer), a number is inserted with its exact value if it is within the column range. The expression is exact and is evaluated using integer arithmetic and has a ...
https://dev.mysql.com/doc/refman/9.7/en/comparison-operators.html
This means that LEAST("11", "45", "2") + 0 evaluates to "11" + 0 and thus to integer 11. Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= ...
https://dev.mysql.com/doc/refman/9.7/en/diagnostics-area.html
The statement information part of the diagnostics area contains these items: NUMBER: An integer indicating the number of condition areas that have information. ROW_COUNT: An integer indicating the number of rows affected by the statement. SQL ...
https://dev.mysql.com/doc/refman/9.7/en/example-auto-increment.html
Use the smallest integer data type for the AUTO_INCREMENT column that is large enough to hold the maximum sequence value you require. See Section 13.1.2, “Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT” for the ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...
https://dev.mysql.com/doc/refman/9.7/en/glossary.html
In addition to enabling fast lookup of related information, foreign keys help to enforce referential integrity, by preventing any of these pointers from becoming invalid as data is inserted, updated, and deleted. See Also child table, FOREIGN KEY ...