MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 1311 to 1320 of 1321 total results

14.20.2 Window Function Concepts and Syntax

https://dev.mysql.com/doc/refman/8.0/en/window-functions-usage.html

However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation occurs is called the current row. The query rows related to the current ...

8.3.4 Connecting to MySQL Remotely from Windows with SSH

https://dev.mysql.com/doc/refman/8.0/en/windows-and-ssh.html

At this point, you should have an ODBC connection to MySQL, encrypted using SSH. This section describes how to get an encrypted connection to a remote MySQL server with SSH. This userid value might not be the same as the user name of your MySQL ...

10.12.2.3 Using Symbolic Links for Databases on Windows

https://dev.mysql.com/doc/refman/8.0/en/windows-symbolic-links.html

If you already have a database directory named mydb in the data directory, move it to D:\data. On Windows, symbolic links can be used for database directories. This enables you to put a database directory at a different location (for example, on a ...

2.3.4.9 Testing The MySQL Installation

https://dev.mysql.com/doc/refman/8.0/en/windows-testing.html

If you have set a password for the root account, deleted the anonymous account, or created a new user account, then to connect to the MySQL server you must use the appropriate -u and -p options with the commands shown previously. In this case, start ...

2.3.5 Troubleshooting a Microsoft Windows MySQL Server Installation

https://dev.mysql.com/doc/refman/8.0/en/windows-troubleshooting.html

If you have installed MySQL to a directory other than C:\Program Files\MySQL\MySQL Server 8.0, ensure that the MySQL server is aware of this through the use of a configuration (my.ini) file. When installing and running MySQL for the first time, you ...

5.3.4.6 Working with NULL Values

https://dev.mysql.com/doc/refman/8.0/en/working-with-null.html

The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. In MySQL, 0 or NULL means false and anything else means true. This special ...

22.5.6.2 X Plugin Options and System Variables

https://dev.mysql.com/doc/refman/8.0/en/x-plugin-options-system-variables.html

The host system must support network namespaces and each named namespace must previously have been set up. To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Type Enumeration Default Value ON ...

22.5.4 Using X Plugin with the Caching SHA-2 Authentication Plugin

https://dev.mysql.com/doc/refman/8.0/en/x-plugin-sha2-cache-plugin.html

Before you can use non-SSL X Protocol connections to authenticate an account that uses the caching_sha2_password authentication plugin, the account must have authenticated at least once over an X Protocol connection with SSL, to supply the password ... X Plugin supports MySQL user accounts created with the caching_sha2_password authentication ...

15.3.8.2 XA Transaction States

https://dev.mysql.com/doc/refman/8.0/en/xa-states.html

An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...

15.3.8 XA Transactions

https://dev.mysql.com/doc/refman/8.0/en/xa.html

This takes place after the actions performed by the branches of the global transaction have been executed. Support for XA transactions is available for the InnoDB storage engine. The MySQL XA implementation is based on the X/Open CAE document ...

Displaying 1311 to 1320 of 1321 total results