PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/upgrading.html
SQL statements can be executed using the mysql command-line client (connect as root to ensure that you have the necessary privileges). This chapter describes the steps to upgrade a MySQL installation. Upgrading is a common procedure, as you pick up ...
https://dev.mysql.com/doc/refman/8.0/en/using-date.html
To have MySQL check all dates and accept only legal dates (unless overridden by IGNORE), set the sql_mode system variable to "NO_ZERO_IN_DATE,NO_ZERO_DATE". You should use this format in UPDATE expressions and in the WHERE clause of SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/using-explain.html
If you have a problem with indexes not being used when you believe that they should be, run ANALYZE TABLE to update table statistics, such as cardinality of keys, that can affect the choices the optimizer makes. The EXPLAIN statement provides ...
https://dev.mysql.com/doc/refman/8.0/en/using-gdb-on-mysqld.html
In this case, you can only have one thread active at a time. On most systems you can also start mysqld from gdb to get more information if mysqld crashes. With some older gdb versions on Linux you must use run --one-thread if you want to be able to ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-transitioning.html
Note In MySQL 8.0, the validate_password plugin was reimplemented as the validate_password component. The validate_password plugin is deprecated; expect it to be removed in a future version of MySQL. MySQL installations that currently use the ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password.html
The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential passwords. This component exposes system variables that enable you to configure password policy, and status ...
https://dev.mysql.com/doc/refman/8.0/en/verifying-index-usage.html
Always check whether all your queries really use the indexes that you have created in the tables. Use the EXPLAIN statement, as described in Section 10.8.1, “Optimizing Queries with EXPLAIN”.
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-reference.html
System variables: version_tokens_session Command-Line Format --version-tokens-session=value System Variable version_tokens_session Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type String Default Value NULL The session value of this ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html
Without ORDER BY, all rows are peers and have value N/N = 1, where N is the partition size. This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that row. Most aggregate ...
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) [, ...