PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-syntax.html
If you specify ZEROFILL for a numeric column, MySQL automatically adds the UNSIGNED attribute to the column. Numeric data types that permit the UNSIGNED attribute also permit SIGNED. SERIAL is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-conflict-resolution.html
This column should be defined as follows: NDB$ORIG_TRANSID BIGINT UNSIGNED NOT NULL NDB$ORIG_TRANSID is a 64-bit value generated by NDB. Create the test.t1 table: CREATE TABLE test.t1 ( columns mycol INT UNSIGNED, columns ) ENGINE=NDB; Now, when ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
Arguments: millisec: An unsigned integer that specifies the number of milliseconds to sleep. For information about using JSON data in MySQL, see Section 11.5, “The JSON Data Type”. Filter definitions have this form, where actions indicates how ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_binlog_index Table ndb_replication Table 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 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
NodeId Version (or later) NDB 7.5.0 Type or units unsigned Default [...] Range 1 - 48 Restart Type Initial System Restart: Requires a complete shutdown of the cluster, wiping and restoring the cluster file system from a backup, and then restarting ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
The following statement displays the possible names: SELECT REPLACE(EVENT_NAME, 'statement/sql/', '') AS name FROM performance_schema.events_statements_summary_global_by_event_name WHERE EVENT_NAME LIKE 'statement/sql/%' ORDER BY name; ... The MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/bit-functions.html
In particular, if the shift count is greater or equal to the width of an unsigned 64-bit number, the result is zero. In particular, if the shift count is greater or equal to the width of an unsigned 64-bit number, the result is zero. mysql> SELECT 5 ... Table 12.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/5.7/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
NO_UNSIGNED_SUBTRACTION Subtraction between integer values, where one is of type UNSIGNED, produces an unsigned result by default. When NO_UNSIGNED_SUBTRACTION is enabled, the subtraction result is signed, even if any operand is unsigned. The MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
For numeric operators (such as + or -) where one of the operands is an unsigned integer, the result is unsigned by default (see Section 12.6.1, “Arithmetic Operators”). To override this, use the SIGNED or UNSIGNED cast operator to cast a value ... Table 12.15 Cast Functions and Operators Name Description BINARY Cast a string to a binary string CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...