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/option-modifiers.html
For example, the mysql client supports a --column-names option that determines whether or not to display a row of column names at the beginning of query results. To disable column names, you can specify the option using any of these forms: ... Some ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-prepared-statements-instances-table.html
The prepared_statements_instances table has these columns: OBJECT_INSTANCE_BEGIN The address in memory of the instrumented prepared statement. For the text protocol, this column is the external statement name assigned by the user. OWNER_THREAD_ID, ... The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary ...
https://dev.mysql.com/doc/refman/5.7/en/replace.html
Values for all columns are taken from the values specified in the REPLACE statement. Any missing columns are set to their default values, just as happens for INSERT. If you use an assignment such as SET col_name = col_name + 1, the reference to the ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
SHOW TABLE STATUS output has these columns: Name The name of the table. (In-memory data resource usage is reported by the Data_length column.) For partitioned tables, this value is only an estimate and may not be absolutely correct. The Update_time ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/5.7/en/account-upgrades.html
The MySQL server authenticates connection attempts for each account listed in the mysql.user system table using the authentication plugin named in the plugin column. If the plugin column is empty, the server authenticates the account as follows: ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
For MyISAM tables, COUNT(*) is optimized to return very quickly if the SELECT retrieves from one table, no other columns are retrieved, and there is no WHERE clause. COUNT(1) is only subject to the same optimization if the first column is defined as ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/5.7/en/compressed-format.html
If values in an integer column have a small range, the column is stored using the smallest possible type. For example, a BIGINT column (eight bytes) can be stored as a TINYINT column (one byte) if all its values are in the range from -128 to 127. If ... Compressed storage format is a read-only format that is generated with the myisampack ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-enum.html
ENUM and SET columns provide an efficient way to define columns that can contain only a given set of values. Unless strict mode is disabled (not recommended, but see Section 5.1.10, “Server SQL Modes”), the definition of a ENUM or SET column ...
https://dev.mysql.com/doc/refman/5.7/en/cost-model.html
DBAs can use this column to provide information about why a cost estimate row stores a particular value. The primary key for the server_cost table is the cost_name column, so it is not possible to create multiple entries for any cost estimate. The ... To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
Support for aliases on tables and columns as required by standard SQL. Each index may consist of 1 to 16 columns or parts of columns. An index may use a prefix of a column for CHAR, VARCHAR, BLOB, or TEXT column types. For example, the Scandinavian ... This section describes some of the important characteristics of the MySQL Database ...