PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/federated-create-server.html
See the following table for information on the correspondence between parameters in a connection string, options in the CREATE SERVER statement, and the columns in the mysql.servers table. For reference, the format of the CONNECTION string is as ...
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/general-thread-states.html
It is deleting only from the first table, and saving columns and offsets to be used for deleting from the other (reference) tables. It is updating only the first table, and saving columns and offsets to be used for updating the other (reference) ...
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 ...