MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 901 to 910 of 912 total results

https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html

The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It is not possible to create an index on a view. Indexes can be used for views processed using the merge algorithm. However, a ...

27.5.3 Updatable and Insertable Views

https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html

Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...

10.2.1.1 WHERE Clause Optimization

https://dev.mysql.com/doc/refman/8.0/en/where-optimization.html

This section discusses optimizations that can be made for processing WHERE clauses. The examples use SELECT statements, but the same optimizations apply for WHERE clauses in DELETE and UPDATE statements. Note Because work on the MySQL optimizer is ...

14.20.4 Named Windows

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

Windows can be defined and given names by which to refer to them in OVER clauses. If present in a query, the WINDOW clause falls between the positions of the HAVING and ORDER BY clauses, and has this syntax: WINDOW window_name AS (window_spec) [, ...

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

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 account. Either do a remote forward (Set local_port: 3306, remote_host: ...

8.4.1.6 Windows Pluggable Authentication

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

Note Windows pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition for Windows supports an authentication method that performs external authentication on Windows, enabling ...

2.3.6 Windows Postinstallation Procedures

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

GUI tools exist that perform most of the tasks described in this section, including: MySQL Installer: Used to install and upgrade MySQL products. If necessary, initialize the data directory and create the MySQL grant tables. Windows installation ...

2.3.7 Windows Platform Restrictions

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

The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including MySQL. This is because the physical ...

3.11 Upgrading MySQL on Windows

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

There are two approaches for upgrading MySQL on Windows: Using MySQL Installer Using the Windows ZIP archive distribution The approach you select depends on how the existing installation was performed. Before proceeding, review Chapter 3, Upgrading ...

Displaying 901 to 910 of 912 total results