PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-prerequisites.html
Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to work.
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-reference.html
If a token exists, its value is updated with the given value. | +-----------------------------------------------+ mysql> SELECT version_tokens_edit('tok2=new_value2;tok3=new_value3'); +--------------------------------------------------------+ | ...
https://dev.mysql.com/doc/refman/8.0/en/alter-tablespace.html
RENAME TO operations are implicitly performed in autocommit mode, regardless of the autocommit setting. It can be used to add a new data file to, or to drop a data file from an NDB tablespace. It can also be used to rename an NDB Cluster Disk Data ...
https://dev.mysql.com/doc/refman/8.0/en/arithmetic-functions.html
For subtraction, if the NO_UNSIGNED_SUBTRACTION SQL mode is enabled, the result is signed even if any operand is unsigned. Table 14.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus ...
https://dev.mysql.com/doc/refman/8.0/en/comments.html
If there is a concern that optimizer-hint comments may be stored in object definitions so that dump files when reloaded with mysql would result in execution of such commands, either invoke mysql with the --binary-mode option or use a reload client ... MySQL Server supports three comment styles: From a # character to the end of the ...
https://dev.mysql.com/doc/refman/8.0/en/counting-rows.html
Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> ...
https://dev.mysql.com/doc/refman/8.0/en/creating-rsa-files-using-openssl.html
This section describes how to use the openssl command to set up the RSA key files that enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password and caching_sha2_password plugins. Note There are easier alternatives to generating the files required for RSA than the procedure described here: Let the server autogenerate them or use the mysql_ssl_rsa_setup program (deprecated as of MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files-using-mysql.html
On Unix and Unix-like systems, the file access mode is 644 for certificate files (that is, world readable) and 600 for key files (that is, accessible only by the account that runs the server). MySQL provides these ways to create the SSL certificate ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
This is enforced beginning with MySQL 8.0.22, regardless of the server SQL mode setting. Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, ...
https://dev.mysql.com/doc/refman/8.0/en/debugging-client.html
Do this by running mysql in debugging mode (assuming that you have compiled MySQL with debugging on): $> mysql --debug=d:t:O,/tmp/client.trace This provides useful information in case you mail a bug report. To be able to debug a MySQL client with ...