PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-virtual-table.html
The INNODB_SYS_VIRTUAL table provides metadata about InnoDB virtual generated columns and columns upon which virtual generated columns are based, equivalent to information in the SYS_VIRTUAL table in the InnoDB data dictionary. A row appears in the ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
Such hashes look like this: mysql> SELECT PASSWORD('mypass'); +--------------------+ | PASSWORD('mypass') | +--------------------+ | 6f8c114b58f2ce9e | +--------------------+ To store account passwords, the Password column of the user table was at ... Note The information in this section applies fully only before MySQL 5.7.5, and only for accounts that use the mysql_native_password or mysql_old_password authentication ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
--complete-insert Command-Line Format --complete-insert Write complete INSERT statements that include column names. --hex-blob Command-Line Format --hex-blob Dump binary columns using hexadecimal notation (for example, 'abc' becomes 0x616263). While ... mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
In MySQL row-based replication, each row change event contains two images, a “before” image whose columns are matched against when searching for the row to be updated, and an “after” image containing the changes. Normally, MySQL logs full ...
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. Most of the reserved words in the list are forbidden by standard SQL as column or table names (for ...This may also be true for the names of built-in ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB table. NDB_COLUMN can be used in a column comment to set the size of the blob parts table ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
There are multiple ways to cause MySQL to accept the query: Alter the table to make name a primary key or a unique NOT NULL column. This may be useful if you simply do not care which value of a nonaggregated column is chosen for each group. The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
--ndb-default-column-format=[FIXED|DYNAMIC] Command-Line Format --ndb-default-column-format={FIXED|DYNAMIC} Introduced 5.7.11-ndb-7.5.1 System Variable ndb_default_column_format Scope Global Dynamic Yes Type Enumeration Default Value (≥ ... This ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
This optional display width may be used by applications to display integer values having a width less than the width specified for the column by left-padding them with spaces. Whether it is used is up to the application.) The display width does not ... MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the ...
https://dev.mysql.com/doc/refman/5.7/en/union.html
Selected columns listed in corresponding positions of each SELECT statement should have the same data type. For example, the first column selected by the first statement should have the same type as the first column selected by the other statements.