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/prepare.html
Parameter markers can be used only where data values should appear, not for SQL keywords, identifiers, and so forth. PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to ...
https://dev.mysql.com/doc/refman/8.0/en/program-variables.html
Both set the size of the server's key buffer to 512MB: [mysqld] key_buffer_size=512M [mysqld] key-buffer-size=512M Suffixes for specifying a value multiplier can be used when setting a variable at program invocation time, but not to set the value ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-repuser.html
Important To connect to the source using a user account that authenticates with the caching_sha2_password plugin, you must either set up a secure connection as described in Section 19.3.1, “Setting Up Replication to Use Encrypted Connections”, ... Each replica connects to the source using a MySQL user name and password, so there must be a user account on the source that the replica can use to ...
https://dev.mysql.com/doc/refman/8.0/en/select-optimization.html
Indexes are especially important for queries that reference different tables, using features such as joins and foreign keys. With efficient use of the InnoDB buffer pool, MyISAM key cache, and the MySQL query cache, repeated queries run faster ...
https://dev.mysql.com/doc/refman/8.0/en/select.html
For example: SELECT CONCAT(last_name,', ',first_name) AS full_name FROM mytable ORDER BY full_name; The AS keyword is optional when aliasing a select_expr with an identifier. You can use SET max_seeks_for_key=value as an alternative way to force ...
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
As of yet, there are no INFORMATION_SCHEMA tables that correspond exactly to mysql.foreign_keys, mysql.foreign_key_column_usage. The standard SQL way to obtain foreign key information is by using the INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS and ...
https://dev.mysql.com/doc/refman/8.0/en/unix-signal-response.html
Some command interpreters associate certain key sequences with signals, such as Control+C to send a SIGINT signal. On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html
For example: mysqld_safe --user=mysql --datadir=/path/to/existing-datadir & If there are encrypted InnoDB tablespaces, use the --early-plugin-load option to load the keyring plugin. This section describes how to upgrade MySQL binary and ...
https://dev.mysql.com/doc/refman/8.0/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-encrypted-connections.html
For example, X Plugin can have SSL key, certificate, and certificate authority files that differ from those used for MySQL Server. This section explains how to configure X Plugin to use encrypted connections. To enable configuring support for ...