Search Results
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-installation.html
To install the component, issue this INSTALL COMPONENT statement: INSTALL COMPONENT "file://component_enterprise_encryption"; INSTALL COMPONENT requires the INSERT privilege for the mysql.component system table because it adds a row to that table to ... The functions are provided by a MySQL component component_enterprise_encryption, and installing the component installs all of the ...
https://dev.mysql.com/doc/refman/8.4/en/error-interfaces.html
SHOW ENGINE INNODB STATUS statement output includes information about the most recent foreign key error if a CREATE TABLE statement for an InnoDB table fails. Error messages can originate on the server side or the client side, and each error ...
https://dev.mysql.com/doc/refman/8.4/en/example-maximum-column-group-row.html
Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause, a LEFT JOIN, or a common table expression with a window function. Common table expression with window function: WITH s1 AS ( SELECT article, dealer, ... Task: For each article, find the dealer or dealers with the most expensive ...
https://dev.mysql.com/doc/refman/8.4/en/exists-and-not-exists-subqueries.html
If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. For example: SELECT column1 FROM t1 WHERE EXISTS (SELECT * FROM t2); Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-elements.html
The MYSQL_FIREWALL plugin, along with server-side plugins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL_WHITELIST implement Performance Schema and INFORMATION_SCHEMA tables that provide views into the registered profiles. Tables in the firewall ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-installation.html
The available scripts differ in the file name used to refer to the script: win_install_firewall.sql linux_install_firewall.sql The installation script creates stored procedures and tables in the firewall database you specify when you run the script.
https://dev.mysql.com/doc/refman/8.4/en/full-text-adding-collation.html
Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. The server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is also issued ...
https://dev.mysql.com/doc/refman/8.4/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range ...The ...
https://dev.mysql.com/doc/refman/8.4/en/gis-data-formats.html
For example, a WKB value that corresponds to POINT(1 -1) consists of this sequence of 21 bytes, each represented by two hexadecimal digits: 0101000000000000000000F03F000000000000F0BF The sequence consists of the components shown in the following ...
https://dev.mysql.com/doc/refman/8.4/en/gis-linestring-property-functions.html
A unit is supported if it is found in the INFORMATION_SCHEMA ST_UNITS_OF_MEASURE table. You can extract particular points of a LineString, count the number of points that it contains, or obtain its length. Unless otherwise specified, functions in ...