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/choosing-types.html
For example, if an integer column is used for values in the range from 1 to 99999, MEDIUMINT UNSIGNED is the best type. This enables you to do all calculations with 64-bit integers and then convert results back to floating-point values as necessary.
https://dev.mysql.com/doc/refman/9.7/en/create-spatial-reference-system.html
srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and ...
https://dev.mysql.com/doc/refman/9.7/en/data-type-defaults.html
In the definition of an integer column, it is an alias for NOT NULL AUTO_INCREMENT UNIQUE. Implicit defaults are defined as follows: For numeric types, the default is 0, with the exception that for integer or floating-point types declared with the ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/9.7/en/drop-spatial-reference-system.html
DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid srid: 32-bit unsigned integer This statement removes a spatial reference system (SRS) definition from the data dictionary. To identify which column or columns use the SRID, use this query: SELECT * ...
https://dev.mysql.com/doc/refman/9.7/en/firewall-component.html
ID An integer column that is a primary key for the table. component_firewall.reload_interval_seconds System Variable component_firewall.reload_interval_seconds Scope Global Dynamic No SET_VAR Hint Applies No Type Integer Default Value 0 Minimum ...
https://dev.mysql.com/doc/refman/9.7/en/gis-general-property-functions.html
If any SRID argument is not within the range of a 32-bit unsigned integer, an ER_DATA_OUT_OF_RANGE error occurs. ST_SRID(g [, srid]) With a single argument representing a valid geometry object g, ST_SRID() returns an integer indicating the ID of the ... The functions listed in this section do not restrict their argument and accept a geometry value of any ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-view-changes.html
The view identifier itself is built from two parts: a randomly generated part, and a monotonically increasing integer. When Group Replication's distributed recovery process is carrying out state transfer from the binary log, to synchronize the ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-partitions-table.html
For a RANGE partition, it contains the value set in the partition's VALUES LESS THAN clause, which can be either an integer or MAXVALUE. For a LIST partition, this column contains the values defined in the partition's VALUES IN clause, which is a ...
https://dev.mysql.com/doc/refman/9.7/en/innochecksum.html
It was originally developed to speed up verifying the integrity of tablespace files after power outages but can also be used after file copies. Example usage: innochecksum --end-page=700 ../data/test/tab1.ibd or: innochecksum --p 700 ...This tool ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...