Search Results
https://dev.mysql.com/doc/refman/8.4/en/gis-class-geometry.html
If a larger value is given, only the lower 32 bits are used. It is a noninstantiable class but has a number of properties, described in the following list, that are common to all geometry values created from any of the Geometry subclasses. Geometry ...
https://dev.mysql.com/doc/refman/8.4/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/8.4/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. The functions listed in this section do not restrict their argument and accept a geometry value of any type. Unless otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
To accommodate granting rights to users from arbitrary hosts, MySQL supports specifying the user value in the form 'user_name'@'host_name'. If you are using table, column, or routine privileges for even one user, the server examines table, column, ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary operations. ROLLUP thus enables you to answer questions at multiple levels of ...
https://dev.mysql.com/doc/refman/8.4/en/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 7.1.17, ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
LAST_INSERT_ID(), LAST_INSERT_ID(expr) With no argument, LAST_INSERT_ID() returns a BIGINT UNSIGNED (64-bit) value representing the first automatically generated value successfully inserted for an AUTO_INCREMENT column as a result of the most ...It ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-columns-table.html
PRTYPE The InnoDB “precise type”, a binary value with bits representing MySQL data type, character set code, and nullability. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-foreign-table.html
TYPE A collection of bit flags with information about the foreign key column, ORed together. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_FOREIGN table has these ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-indexes-table.html
TYPE A numeric value derived from bit-level information that identifies the index type. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_INDEXES table has these ...