MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 31 to 40 of 1139 total results

15.1.19 CREATE SPATIAL REFERENCE SYSTEM Statement

https://dev.mysql.com/doc/refman/8.0/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 ...

13.4.10 Creating Spatial Indexes

https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-indexes.html

For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...A B-tree index on spatial values is useful for exact-value lookups, but not for range ...

15.7.7.6 SHOW CREATE DATABASE Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-database.html

SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name Shows the CREATE DATABASE statement that creates the named database. row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET ...If ...

15.7.7.11 SHOW CREATE TRIGGER Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-trigger.html

SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER statement that creates the named trigger. row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...

15.1.22 CREATE TRIGGER Statement

https://dev.mysql.com/doc/refman/8.0/en/create-trigger.html

CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | ...

8.3.3.1 Creating SSL and RSA Certificates and Keys using MySQL

https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files-using-mysql.html

MySQL provides these ways to create the SSL certificate and key files and RSA key-pair files required to support encrypted connections using SSL and secure password exchange using RSA over unencrypted connections, if those files are missing: The ...

18.8.2 How to Create FEDERATED Tables

https://dev.mysql.com/doc/refman/8.0/en/federated-create.html

To create a FEDERATED table you should follow these steps: Create the table on the remote server. Alternatively, make a note of the table definition of an existing table, perhaps using the SHOW CREATE TABLE statement. Create the table on the local ...Note You can improve the performance of a FEDERATED table by adding indexes to the table on the ...

1.3 What Is New in MySQL 8.0

https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html

Previously, an account-management statement (such as CREATE USER or DROP USER) that named multiple users could succeed for some users and fail for others. As of MySQL 8.0.27, MySQL supports multifactor authentication (MFA), which makes it possible ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...

15.7.2.2 CREATE RESOURCE GROUP Statement

https://dev.mysql.com/doc/refman/8.0/en/create-resource-group.html

CREATE RESOURCE GROUP group_name TYPE = {SYSTEM|USER} [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE] vcpu_spec: {N | M - N} CREATE RESOURCE GROUP is used for resource group management (see Section 7.1.16, ...It ...

15.7.7.7 SHOW CREATE EVENT Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-event.html

SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. For example (using the same event e_daily defined and then altered in Section 15.7.7.18, “SHOW EVENTS Statement”): mysql> SHOW ...

Displaying 31 to 40 of 1139 total results