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/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 14.6.1, “Arithmetic Operators”). To override this, use the SIGNED or UNSIGNED cast operator to cast a value ... Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes 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 ...
https://dev.mysql.com/doc/refman/9.7/en/create-index.html
In each case, the JSON array is cast to an SQL data type array of UNSIGNED integer values. In other words, the ALTER TABLE statement just shown could have used comp(id, (CAST(custinfo->'$.zipcode' AS UNSIGNED ARRAY), modified)) (or any other ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-config-values.html
row *************************** Name: NodeId Node: 2 Type: unsigned Default: Minimum: 1 Maximum: 144 Required: Y Current: 2 *************************** 2. row *************************** Name: TotalSendBufferMemory Node: 2 Type: unsigned Default: 0 ... The config_values table provides information about the current state of node configuration parameter ...
https://dev.mysql.com/doc/refman/9.7/en/aggregate-functions.html
Numeric evaluation occurs otherwise, with argument value conversion to unsigned 64-bit integers as necessary. Numeric evaluation occurs otherwise, with argument value conversion to unsigned 64-bit integers as necessary. Numeric evaluation occurs ...
https://dev.mysql.com/doc/refman/9.7/en/atomic-ddl.html
An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation. The operation is either committed, with applicable changes persisted to ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-differing-tables.html
ALL_SIGNED,ALL_UNSIGNED Treat promoted integer types as signed if possible, otherwise as unsigned. ALL_SIGNED tells the replica to treat all promoted integer types as signed; ALL_UNSIGNED instructs it to treat these as unsigned. Specifying both ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-config.html
Deprecated parameters are indicated in the XML output by the deprecated attribute, as shown here: <param name="NoOfDiskPagesToDiskAfterRestartACC" comment="DiskCheckpointSpeed" type="unsigned" default="20" min="1" max="4294967039" ... This tool ...
https://dev.mysql.com/doc/refman/9.7/en/numeric-type-attributes.html
An unsigned type can be used to permit only nonnegative numbers in a column or when you need a larger upper numeric range for the column. For example, if an INT column is UNSIGNED, the size of the column's range is the same but its endpoints shift ... MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the ...
https://dev.mysql.com/doc/refman/9.7/en/ansi-diff-foreign-keys.html
For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent rows. This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-fulltext-index.html
If you want to create your own FTS_DOC_ID column, the column must be defined as BIGINT UNSIGNED NOT NULL and named FTS_DOC_ID (all uppercase), as in the following example: Note The FTS_DOC_ID column does not need to be defined as an AUTO_INCREMENT ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...