Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-connection.html
These variables can be changed individually using SET statements, but two more convenient statements affect the connection-related character set system variables as a group: SET NAMES 'charset_name' [COLLATE 'collation_name'] SET NAMES indicates ...
https://dev.mysql.com/doc/refman/8.4/en/cleartext-pluggable-authentication.html
Also, any program that uses libmysqlclient and reads option files can enable the plugin by including an enable-cleartext-plugin option in an option group read by the client library. A client-side authentication plugin is available that enables ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-failure-handling.html
Configuring a longer timeout allows more time for resolving network issues but also increases the size of the delta on the donor instance, which increases clone recovery time as well as replication lag in cases where the clone is intended as a ...
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 ...