Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-function-loadable.html
The AGGREGATE keyword, if given, signifies that the function is an aggregate (group) function. CREATE [AGGREGATE] FUNCTION [IF NOT EXISTS] function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This statement loads the ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/create-table-foreign-keys.html
Previously, InnoDB allowed a foreign key to reference any index column or group of columns, even a non-unique index or partial index, an extension of standard SQL. MySQL supports foreign keys, which permit cross-referencing related data across ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/data-masking-plugin-functions.html
The MySQL Enterprise Data Masking and De-Identification plugin library includes several functions, which may be grouped into these categories: Data Masking Plugin Functions Random Data Generation Plugin Functions Random Data Dictionary-Based Plugin ...If a string return value should be in a different character set, convert ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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 ...