PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html
Numeric evaluation occurs otherwise, with argument conversion to unsigned 64-bit integers as necessary. Numeric evaluation occurs otherwise, with argument conversion to unsigned 64-bit integers as necessary. Numeric evaluation occurs otherwise, with ... Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit functions and operators: | Bitwise ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-import.html
--ai-increment=# Command-Line Format --ai-increment=# Type Integer Default Value 1 Minimum Value 1 Maximum Value 4294967295 For a table with a hidden primary key, specify the autoincrement increment, like the auto_increment_increment system variable ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
group_replication_auto_increment_increment Command-Line Format --group-replication-auto-increment-increment=# System Variable group_replication_auto_increment_increment Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 7 ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
The argument N is interpreted as an integer, but may be specified as an integer or a string. mysql> SELECT EXP(2); -> 7.3890560989307 mysql> SELECT EXP(-2); -> 0.13533528323661 mysql> SELECT EXP(0); -> 1 FLOOR(X) Returns the largest integer value ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-options-system-variables.html
mysqlx_connect_timeout Command-Line Format --mysqlx-connect-timeout=# System Variable mysqlx_connect_timeout Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 30 Minimum Value 1 Maximum Value 1000000000 Unit seconds The ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html
For integer data types, M indicates the minimum display width. As of MySQL 8.0.17, the display width attribute is deprecated for integer data types; you should expect support for it to be removed in a future version of MySQL. SERIAL DEFAULT VALUE ...Display width is unrelated to the range of values a type can store, as described in Section 13.1.6, “Numeric Type ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
--max-binlog-dump-events=N Command-Line Format --max-binlog-dump-events=# Type Integer Default Value 0 This option is used internally by the MySQL test suite for replication testing and debugging. binlog_expire_logs_seconds Command-Line Format ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
For example, if a subquery returns an integer to be compared to a DATETIME value, the comparison is done as two integers. The arguments are compared as decimal values if the other argument is a decimal or integer value, or as floating-point values ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
Example: <STARTUP_OPTIONS>/usr/local/mysql/bin/mysqld --port=3306 --log_output=FILE</STARTUP_OPTIONS> <STATUS> An unsigned integer representing the command status: 0 for success, nonzero if an error occurred. Example: <STATUS>1051</STATUS> ... The ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
AUTO_INCREMENT An integer or floating-point column can have the additional attribute AUTO_INCREMENT. If a table has a PRIMARY KEY or UNIQUE NOT NULL index that consists of a single column that has an integer type, you can use _rowid to refer to the ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...