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
Within the statement, ? characters can be used as parameter markers to indicate where data values are to be bound to the query later when you execute it. The ? characters should not be enclosed within quotation marks, even if you intend to bind them ... PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement ...
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
Values used for SOURCE_HOST and other CHANGE REPLICATION SOURCE TO options are checked for linefeed (\n or 0x0A) characters. The presence of such characters in these values causes the statement to fail with an error. When the receiver thread is ...] ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-names.html
MySQL collation names follow these conventions: A collation name starts with the name of the character set with which it is associated, generally followed by one or more suffixes indicating other collation characteristics. For example, ...
https://dev.mysql.com/doc/refman/8.0/en/charset-metadata.html
Representation of metadata must satisfy these requirements: All metadata must be in the same character set. Otherwise, neither the SHOW statements nor SELECT statements for tables in INFORMATION_SCHEMA would work properly because different rows in ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/8.0/en/identifiers.html
If an identifier contains special characters or is a reserved word, you must quote it whenever you refer to it. The permissible Unicode characters in identifiers are those in the Basic Multilingual Plane (BMP). Identifiers thus may contain these ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html
charset charset_name, \C charset_name Change the default character set and issue a SET NAMES statement. This enables the character set to remain synchronized on the client and server if mysql is run with auto-reconnect enabled (which is not ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
It does not indicate the number of characters, which varies according to the character set and collation used by the column. NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment ...
https://dev.mysql.com/doc/refman/8.0/en/error-message-elements.html
These elements have the following characteristics: Error code: This value is numeric. SQLSTATE value: This value is a five-character string (for example, '42S02'). The first two characters of an SQLSTATE value indicate the error class: Class = '00' ... This section discusses how error messages originate within MySQL and the elements they ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
The output does not explicitly list the table default character set, but the collation name begins with the character set name. The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
Whether to adjust the size of the buffer pool based on run-time performance characteristics, such as the amount of time the system spends compressing and uncompressing data. When to Use Compression In general, compression works best on tables that ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...