Search Results
https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html
For example, if a table contains a TIMESTAMP column named ts, standard SQL permits PARTITION BY ts but not PARTITION BY HOUR(ts), whereas MySQL permits both. However, whereas an aggregate operation groups query rows into a single result row, a ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-connection-compression.html
The following table compares the characteristics of the different compression algorithms and shows their assigned priorities. Instead, its default is to permit all algorithms shown in Table 22.1, “X Protocol Compression Algorithm ... X Plugin ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-options.html
Options for information such as SSL certificate and key files are used to establish an encrypted connection if such connections are available, but do not enforce any requirement that the connection obtained be encrypted. The Performance Schema ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins-server-side.html
auth_string: The value of the authentication_string column of the row in the mysql.user system table for the matching account name (that is, the row that matches the client user name and host name and that the server uses to determine how to ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-document-store.html
This tutorial provides instructions to get you started using MySQL as a document store with MySQL Connector/NET. Minimum Requirements MySQL Server 8.0.11 with X Protocol enabled Connector/NET 8.0.11 Visual Studio 2013/2015/2017 world_x database ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-document-store.html
This tutorial provides instructions to get you started using MySQL as a document store with MySQL Connector/NET. Minimum Requirements MySQL Server 8.0.11 with X Protocol enabled Connector/NET 8.0.11 Visual Studio 2013/2015/2017 world_x database ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-abbreviations.html
Throughout this section, we use the following abbreviations or symbols for referring to the source and replica clusters, and to processes and commands run on the clusters or cluster nodes: Table 25.41 Abbreviations used throughout this section ...
https://dev.mysql.com/doc/workbench/en/wb-foreign-key-relationships.html
MySQL Workbench enables you to add a foreign key from within the table editor or from within an EER diagram by using the relationship tools on the vertical toolbar. To add a foreign key using the table editor, see Section 8.1.10.4, “Foreign Keys ... Foreign key constraints are supported for the InnoDB storage engine ...
https://dev.mysql.com/doc/workbench/en/wb-grt-data-organization.html
Workbench model data, such as diagrams, schemas, and tables, is stored in a hierarchy of objects that can be accessed by any plugin. Main Nodes in the Application Object Tree Table C.1 The main nodes in the Application Object Tree Node Description ... The Generic RunTime (GRT) is the internal system used by MySQL Workbench to hold model document ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
The following table shows the mapping between PostgreSQL (source) data types and MySQL data types. Table 10.3 Type mapping Source Type MySQL Type Comment INT INT SMALLINT SMALLINT BIGINT BIGINT SERIAL INT Sets AUTO_INCREMENT in its table definition. BIT BIT BOOLEAN TINYINT(1) REAL FLOAT DOUBLE PRECISION DOUBLE NUMERIC DECIMAL DECIMAL DECIMAL MONEY DECIMAL(19,2) CHAR CHAR/LONGTEXT Depending on its ...