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/faqs-mysql-cluster.html
How do I import an existing MySQL database into an NDB Cluster? A.10.28. How do I import an existing MySQL database into an NDB Cluster? You can import databases into NDB Cluster much as you would with any other version of MySQL. It is also possible ... In the following section, we answer questions that are frequently asked about NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/function-resolution.html
This section describes how the server recognizes whether the name of a built-in function is used as a function call or as an identifier, and how the server determines which function to use in cases when functions of different types exist with a ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
ON DUPLICATE KEY UPDATE statements, the affected-rows value per row is 1 if the row is inserted as a new row, 2 if an existing row is updated, and 0 if an existing row is set to its current values. If you specify the CLIENT_FOUND_ROWS flag, the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
However, InnoDB does check for the existence of tablespace files referenced in the data dictionary. InnoDB does not create directories, so ensure that the specified directory exists before you start the server. For example: [mysqld] ... The first ...
https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
With ON DUPLICATE KEY UPDATE, the affected-rows value per row is 1 if the row is inserted as a new row, 2 if an existing row is updated, and 0 if an existing row is set to its current values. If you specify the CLIENT_FOUND_ROWS flag to the ... If ...
https://dev.mysql.com/doc/refman/5.7/en/join.html
The USING(join_column_list) clause names a list of columns that must exist in both tables. } syntax shown in the join syntax description exists only for compatibility with ODBC. MySQL supports the following JOIN syntax for the table_references part ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-aws-plugin.html
For example, use these lines in the server my.cnf file, adjusting the .so suffix and file locations for your platform as necessary: [mysqld] early-plugin-load=keyring_aws.so ... Note The keyring_aws plugin is an extension included in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
This section describes problems that can occur when using the 2-digit YEAR(2) data type and provides information about converting existing YEAR(2) columns to 4-digit year-valued columns, which can be declared as YEAR with an implicit display width ...Although the internal range of values for YEAR/YEAR(4) and the deprecated YEAR(2) type is the same (1901 to 2155, and 0000), the display width for YEAR(2) makes that type inherently ambiguous because displayed values indicate only the last two digits of the internal values and omit the century ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-column-indexes.html
If separate single-column indexes exist on col1 and col2, the optimizer attempts to use the Index Merge optimization (see Section 8.2.1.3, “Index Merge Optimization”), or attempts to find the most restrictive index by deciding which index ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-general-options.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. The exception is that the .mylogin.cnf file is read in all cases, if it exists. The options ...