PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-errors.html
Character (nonbinary) string values are converted from their character set to UTF-8. Binary string values are copied as is for bytes in the range 0x20 to 0x7E, and using \x hexadecimal encoding for bytes outside that range. If character_set_results ... This section describes how the MySQL server uses character sets for constructing error ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-processes.html
For an executable shipped with the NDB Cluster distribution, node_version shows the two-part MySQL NDB Cluster version string, such as 5.7.44-ndb-7.5.36 or 5.7.44-ndb-7.6.33, that it was compiled with. See Version strings used in NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
SQL syntax for prepared statements does not support multi-statements (that is, multiple statements within a single string separated by ; characters). Using prepared statements with placeholders for parameter values has the following benefits: Less ...
https://dev.mysql.com/doc/refman/5.7/en/charset-binary-set.html
The binary character set is the character set for binary strings, which are sequences of bytes. For the binary character set, the concepts of lettercase and accent equivalence do not apply: For single-byte characters stored as binary strings, ...
https://dev.mysql.com/doc/refman/5.7/en/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For example, if you specified NOT NULL and an explicit DEFAULT value, you should also provide them in the ALTER TABLE statement. For successful ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
For v2, 2 is replaced by a constant string expression (ordering by a constant has no effect, so ordering by any constant works). If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR REPLACE ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-state-table.html
The WAIT_TYPE value is a string that describes the type of wait, as shown in the following table. The TP_THREAD_STATE table has one row per thread created by the thread pool to handle connections. The TP_THREAD_STATE table has these columns: ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
The following table name aliases are used to shorten the query string: INFORMATION_SCHEMA.INNODB_SYS_TABLES: a INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES: b INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS: c An IF() control flow function is used to account ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/doc/refman/5.7/en/literals.html
These include strings, numbers, hexadecimal and bit values, boolean values, and NULL. This section describes how to write literal values in MySQL. The section also covers various nuances that you may encounter when dealing with these basic types in ...