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/show-index.html
This statement requires some privilege for any column in the table. row *************************** Table: city Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: ID Collation: A Cardinality: 4188 Sub_part: NULL Packed: NULL Null: ... SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html
Issuing RESET MASTER or RESET SLAVE resets the values shown in these columns. In other words, this column is useful only for fast networks. This timestamp uses the format YYMMDD hh:mm:ss, and appears in the Last_IO_Error_Timestamp column. Issuing ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. "resulting_clause_is_simple": true, ...row ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
The trigger acts as an accumulator, summing the values inserted into one of the columns of the table. In the example, the trigger body is a simple SET that accumulates into a user variable the values inserted into the amount column. (An example ...
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
If you want to store these results, use a column with a VARBINARY or BLOB binary string data type. If an application stores values from a function such as MD5() or SHA1() that returns a string of hex digits, more efficient storage and comparisons ...
https://dev.mysql.com/doc/refman/5.7/en/explain.html
The description for SHOW COLUMNS provides more information about the output columns. By default, DESCRIBE displays information about all columns in the table. col_name, if given, is the name of a column in the table. In this case, the statement ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-trx-table.html
The INNODB_TRX table has these columns: TRX_ID A unique transaction ID number, internal to InnoDB. To obtain details about the lock, join this column with the LOCK_ID column of the INNODB_LOCKS table. To obtain details about the thread, join this ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
When to Use Compression In general, compression works best on tables that include a reasonable number of character string columns and where the data is read far more often than it is written. Character strings often compress well, whether defined in ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-transporters.html
This information is shown in the table's status column, which can have any one of the following values: CONNECTING, CONNECTED, DISCONNECTING, or DISCONNECTED. The remote_address is the host name or address for the node whose ID is shown in the ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-syntax.html
If you specify ZEROFILL for a numeric column, MySQL automatically adds the UNSIGNED attribute to the column. SERIAL DEFAULT VALUE in the definition of an integer column is an alias for NOT NULL AUTO_INCREMENT UNIQUE. MySQL can handle BIGINT in the ... For integer data types, M indicates the minimum display ...