PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/table.html
For limiting which table columns are returned, filtering rows beyond what can be accomplished using ORDER BY and LIMIT, or both, use SELECT. TABLE is a DML statement which returns rows and columns of the named table. Given the existence of a table ...
https://dev.mysql.com/doc/refman/9.7/en/time-zone-support.html
For instructions for both methods, see Populating the Time Zone Tables. The desired result is that both queries return the same result (the input time, converted to the equivalent value in the 'US/Central' time zone). This section describes the ...
https://dev.mysql.com/doc/refman/9.7/en/timestamp-lookups.html
If the session time zone is UTC, there is effectively no time zone conversion.) Due to conventions for local time zone changes such as Daylight Saving Time (DST), conversions between UTC and non-UTC time zones are not one-to-one in both directions.
https://dev.mysql.com/doc/refman/9.7/en/update.html
For partitioned tables, both the single-single and multiple-table forms of this statement support the use of a PARTITION clause as part of a table reference. This option takes a list of one or more partitions or subpartitions (or both). UPDATE is a ...
https://dev.mysql.com/doc/refman/9.7/en/upgrade-best-practices.html
Run Both MySQL Versions in Parallel To minimize risk, it is best keep the current system running while running the upgraded system in parallel. MySQL supports upgrading between minor versions (within an LTS series) and to the next major version ...
https://dev.mysql.com/doc/refman/9.7/en/upgrading-what-is-upgraded.html
In both cases, the actual version applicable to the existing MySQL installation is stored in the data dictionary, and the current expected version is compiled into the new version of MySQL. If both versions indicate an upgrade is needed, the data ...
https://dev.mysql.com/doc/refman/9.7/en/user-resources.html
One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. This limits the number of simultaneous connections that can be made by any given account, but places no ...
https://dev.mysql.com/doc/refman/9.7/en/using-encrypted-connections.html
There are no status variables to expose the administrative interface TLS context, but the Performance Schema tls_channel_status table exposes TLS properties for both the main and administrative interfaces. The server informs DBAs by providing valid ... Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key ...
https://dev.mysql.com/doc/refman/9.7/en/window-functions-usage.html
The OVER clause has two forms: over_clause: {OVER (window_spec) | OVER window_name} Both forms define how the window function should process query rows. For example, if a table contains a TIMESTAMP column named ts, standard SQL permits PARTITION BY ...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 ...
https://dev.mysql.com/doc/refman/9.7/en/windows-pluggable-authentication.html
Suppose that the Windows user named win_user is a member of win_group and the authentication string looks like this: 'win_group = sql_user1, win_user = sql_user2' When win_user connects to the MySQL server, there is a match both to win_group and to ... Note Windows pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...