PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
In the following section, we answer questions that are frequently asked about NDB Cluster and the NDB storage engine. Which versions of the MySQL software support NDB Cluster? Do I have to compile from source? A.10.2. What is the difference between ...
https://dev.mysql.com/doc/refman/5.7/en/function-resolution.html
The IGNORE_SPACE SQL mode can be used to modify how the parser treats function names that are whitespace-sensitive: With IGNORE_SPACE disabled, the parser interprets the name as a function call when there is no whitespace between the name and the ...
https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html
mysql> CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' Engine=InnoDB; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY) TABLESPACE ts1 Engine=InnoDB; mysql> DROP TABLE t1; mysql> DROP TABLESPACE ts1; Note tablespace_name is a case-sensitive identifier in ... A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
Taxpayer IDs and other sensitive ID numbers also make poor primary keys, because they may need to be secured, encrypted, and otherwise treated differently than other columns. These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/5.7/en/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 5.1.14, ...
https://dev.mysql.com/doc/refman/5.7/en/hexadecimal-literals.html
A leading 0x is case-sensitive and cannot be written as 0X. Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, A..F). Lettercase of the digits and of any leading X does not matter.
https://dev.mysql.com/doc/refman/5.7/en/identifier-mapping.html
(On a case-insensitive file system, both letters are treated as the same.) For some blocks, such as Cyrillic, the second byte determines lettercase. There is a correspondence between database and table identifiers and names in the file system. For ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
Because some MySQL objects are represented as files, searches in INFORMATION_SCHEMA string columns can be affected by file system case sensitivity. INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html
If you are using row-based or mixed-format replication, all of the auto-increment lock modes are safe, since row-based replication is not sensitive to the order of execution of the SQL statements (and the mixed format uses row-based replication for ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...