PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
InnoDB permits a foreign key to reference any index column or group of columns. MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the SELECT. For example: mysql> CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-functions.html
Prior to MySQL 8.0.19, the functions treat string arguments as binary strings (which means they do not distinguish lettercase), and string return values are binary strings. If a MySQL Enterprise Data Masking and De-Identification function is invoked ...
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
Indexes that have descending key parts are not used for MIN()/MAX() optimization of queries that invoke aggregate functions but do not have a GROUP BY clause. MySQL supports descending indexes: DESC in an index definition is no longer ignored but ...
https://dev.mysql.com/doc/refman/8.0/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. Example: DROP SPATIAL REFERENCE SYSTEM 4120; If no SRS definition with the ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-components.html
The following sections describe individual log components, grouped by component type: Filter Error Log Components Sink Error Log Components Component descriptions include these types of information: The component name and intended purpose. This ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-general.html
On Windows, there is currently a limit to the number of (logical) processors that mysqld can use: a single processor group, which is limited to a maximum of 64 logical processors. Why did MySQL version numbering skip versions 6 and 7 and go straight ...
https://dev.mysql.com/doc/refman/8.0/en/file-permissions.html
For example, to give group access to all new directories, start mysqld_safe as follows: UMASK_DIR=504 # = 770 in octal export UMASK_DIR mysqld_safe & For additional details, see Section 6.9, “Environment Variables”. If you have problems with ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-installation.html
$> mysql -u root -p < linux_install_firewall.sql Enter password: (enter root password here) Note To use MySQL Enterprise Firewall in the context of source/replica replication, Group Replication, or InnoDB Cluster, you must prepare the replica nodes ... MySQL Enterprise Firewall installation is a one-time operation that installs the elements described in Section 8.4.7.1, “Elements of MySQL Enterprise ...