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/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 24.2 INFORMATION_SCHEMA General Tables Table Name Description CHARACTER_SETS Available character sets ...
https://dev.mysql.com/doc/refman/5.7/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logs-ndb-messages.html
This section contains information about the messages written to the cluster log in response to different cluster log events.
https://dev.mysql.com/doc/refman/5.7/en/replication-features-views.html
Trying to do so when row-based logging is in effect causes an error. Views are filtered by their own name, not by the tables they refer to. This means that a view can be replicated to the replica even if the view contains a table that would normally ...
https://dev.mysql.com/doc/refman/5.7/en/alter-logfile-group.html
(Bug #13116514, Bug #16104705, Bug #62858) On 32-bit systems, the maximum supported value for INITIAL_SIZE is 4294967296 (4 GB). ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This ...
https://dev.mysql.com/doc/refman/5.7/en/alter-tablespace.html
On 32-bit systems, the maximum supported value for INITIAL_SIZE is 4294967296 (4 GB). ALTER TABLESPACE tablespace_name {ADD | DROP} DATAFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement is used either to add a ...
https://dev.mysql.com/doc/refman/5.7/en/fixed-point-types.html
The maximum number of digits for DECIMAL is 65, but the actual range for a given DECIMAL column can be constrained by the precision or scale for a given column. The DECIMAL and NUMERIC types store exact numeric data values. These types are used ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-instances.html
The maximum number of instances which can be used in a group is nine. The first step is to deploy at least three instances of MySQL Server, this procedure demonstrates using multiple hosts for the instances, named s1, s2, and s3. It is assumed that ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
This convention is recommended for maximum portability and ease of use. In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory (and ...
https://dev.mysql.com/doc/refman/5.7/en/json-function-reference.html
Table 12.22 JSON Functions Name Description Introduced Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...