Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-spatial-reference-system.html
The resulting data dictionary entry can be inspected using the INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS table. With CREATE OR REPLACE syntax, any existing SRS definition with the same SRID value is replaced, unless the SRID value is used by ...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 stores it in the data ...
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE tables. Use the CREATE TABLE statement to create a table ...See also the notes about spatial indexes under Section 13.4.10, “Creating Spatial ...
https://dev.mysql.com/doc/refman/8.4/en/drop-tablespace.html
DROP [UNDO] TABLESPACE tablespace_name This statement drops a tablespace that was previously created using CREATE TABLESPACE. The UNDO keyword must be specified to drop an undo tablespace. Only undo tablespaces created using CREATE UNDO TABLESPACE ...
https://dev.mysql.com/doc/refman/8.4/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. Handling of Enumeration Literals Trailing spaces are automatically deleted from ENUM ...See Section 13.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-configuration.html
INSTALL COMPONENT adds the component to the mysql.component table (an InnoDB table), and the components to load at startup are read from this table, which is only accessible after InnoDB is initialized. Note Loading a log component implicitly using ... In MySQL 8.4, error logging uses the MySQL component architecture described at Section 7.5, “MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
A maximum of 3 JSON columns per NDB table is supported. A direct assignment of the column value (for example, UPDATE mytable SET jcol = '{"a": 10, "b": 25}') cannot be performed as a partial update. The input column and the target column must be the ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/8.4/en/lock-instance-for-backup.html
REPAIR TABLE TRUNCATE TABLE, OPTIMIZE TABLE, and account management statements are blocked. LOCK INSTANCE FOR BACKUP permits DDL operations that only affect user-created temporary tables. In effect, files that belong to user-created temporary tables ... LOCK INSTANCE FOR BACKUP UNLOCK INSTANCE LOCK INSTANCE FOR BACKUP acquires an instance-level backup lock that permits DML during an online backup while preventing operations that could result in an inconsistent ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
There are multiple ways to cause MySQL to accept the query: Alter the table to make name a primary key or a unique NOT NULL column. The following examples use HEX() to display the INET6_ATON() result in printable form: mysql> SELECT ...The function ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-repair-options.html
--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the table. See also the description of this option under table checking options. For a description of the output format, see Section 6.6.4.5, “Obtaining ...--data-file-length=len, -D len Command-Line Format --data-file-length=len Type Numeric The maximum length of the data file (when re-creating data file when it is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-logs-cluster-log.html
The following table lists the most common NDB cluster log messages. Table 25.25 Common NDB cluster log messages Log Message Description Event Name Event Type Priority Severity Node mgm_node_id: Node data_node_id Connected The data node having node ...For information about the cluster log, log events, and event types, see Section 25.6.3, “Event Reports Generated in NDB ...