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/federated-description.html
If the statement produces a result set, each column is converted to internal storage engine format that the FEDERATED engine expects and can use to display the result to the client that issued the original statement. When you create a table using ...
https://dev.mysql.com/doc/refman/5.7/en/federated-usagenotes.html
For example, creating a FEDERATED table with an index prefix fails for VARCHAR, TEXT or BLOB columns. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The ...
https://dev.mysql.com/doc/refman/5.7/en/fetch.html
If a row exists, the fetched columns are stored in the named variables. The number of columns retrieved by the SELECT statement must match the number of output variables specified in the FETCH statement. This statement fetches the next row for the ...
https://dev.mysql.com/doc/refman/5.7/en/fractional-seconds.html
MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, ...For ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
Add a new collation for the character set used by the indexed columns, and alter the columns to use that collation. You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require ...
https://dev.mysql.com/doc/refman/5.7/en/functions.html
Expressions can be written using values from several sources, such as literal values, column values, NULL, variables, built-in functions and operators, loadable functions, and stored functions (a type of stored object). This helps the MySQL parser ... Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause of a SELECT, DELETE, or UPDATE statement, or in SET ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-ndb-transid-mysql-connection-map-table.html
The ndb_transid_mysql_connection_map table has these columns: mysql_connection_id The MySQL server connection ID. Although the names of this table and its columns are displayed using lowercase, you can use uppercase or lowercase when referring to ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimizer-trace-table.html
The OPTIMIZER_TRACE table has these columns: QUERY The text of the traced statement. If this limit is reached, the current trace is not extended (and thus is incomplete), and the MISSING_BYTES_BEYOND_MAX_MEM_SIZE column shows the number of bytes ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-parameters-table.html
Parameter information is similar to the contents of the param_list column in the mysql.proc table. The PARAMETERS table has these columns: SPECIFIC_CATALOG The name of the catalog to which the routine containing the parameter belongs. The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-state-table.html
The TP_THREAD_GROUP_STATE table has these columns: TP_GROUP_ID The thread group ID. The TP_THREAD_GROUP_STATE table has one row per thread group in the thread pool. Each row provides information about the current state of a group. There is at most ...