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/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
These statements are equivalent: SELECT N'some text'; SELECT n'some text'; SELECT _utf8'some text'; For information about these forms of string syntax, see Section 12.3.7, “The National Character Set”, and Section 12.3.8, “Character Set ... A ...Examples: 'a string' "another string" Quoted strings placed next to each other are concatenated to a single ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
Character sets and collations other than the following two combinations of character set and collation are not supported for multi-valued indexes: The binary character set with the default binary collation The utf8mb4 character set with the default ...However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, VARBINARY, ...
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
This avoids potential problems with trailing space removal or character set conversion that would change data values, such as may occur if you use a nonbinary string data type (CHAR, VARCHAR, TEXT). Some encryption functions return strings of ASCII ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-example-data.html
Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
In the following queries, tbl_name can be used as a const table: SELECT * FROM tbl_name WHERE primary_key=1; SELECT * FROM tbl_name WHERE primary_key_part1=1 AND primary_key_part2=2; eq_ref One row is read from this table for each combination of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-differing-tables.html
For example, you can replicate from a CHAR(10) column to another CHAR(10), or from a CHAR(10) column to a CHAR(25) column without any problems. If only ALL_NON_LOSSY is set, but not ALL_LOSSY, then attempting a conversion that would result in the ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
Internationalization Options The following options change how the mysqldump command represents character data with national language settings. --opt Command-Line Format --opt Disabled by skip-opt This option, enabled by default, is shorthand for the ...These may be used when dumping stored programs to preserve their character ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
Some options, which you might not use initially, help tune InnoDB performance characteristics based on machine capacity and your database workload. For the characteristics of each lock mode, see InnoDB AUTO_INCREMENT Lock Modes. For best efficiency, ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
However, by default, no whitespace is permitted in function invocations between the function name and the following ( character. Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers ...