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/load-index.html
tbl_index_list: tbl_name [PARTITION (partition_list)] [{INDEX|KEY} (index_name[, index_name] ...)] [IGNORE LEAVES] partition_list: { partition_name[, partition_name] ... | ALL } The LOAD INDEX INTO CACHE statement preloads a table index into the key ...
https://dev.mysql.com/doc/refman/5.7/en/create-database.html
An error occurs if the database exists and you did not specify IF NOT EXISTS. CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ... create_option: [DEFAULT] { CHARACTER SET [=] charset_name | COLLATE [=] collation_name } CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/show-relaylog-events.html
Note Issuing a SHOW RELAYLOG EVENTS with no LIMIT clause could start a very time- and resource-consuming process because the server returns to the client the complete contents of the relay log (including all statements modifying data that have been ... SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] [channel_option] channel_option: FOR CHANNEL channel Shows the events in the relay log of a ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
In such a setup, applications and users would have no access to the database tables directly, but can only execute specific stored routines. A stored routine is a set of SQL statements that can be stored in the server. Once this has been done, ...
https://dev.mysql.com/doc/refman/5.7/en/bit-type.html
The maximum combined size of all BIT columns used in a given NDB table must not exceed 4096 bits. The BIT data type is used to store bit values. If you assign a value to a BIT(M) column that is less than M bits long, the value is padded on the left ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns.html
Columns using other data types relating to dates or times are not supported as partitioning columns. The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. COLUMNS partitioning enables the use of ...
https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html
For TEMPTABLE, the results from the view are retrieved into a temporary table, which then is used to execute the statement. The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. For MERGE, the text of a ...
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the statement. Most of these statements also cause an implicit commit after ...The intent is to handle each such statement in its own special transaction because it cannot be rolled back ...
https://dev.mysql.com/doc/refman/5.7/en/create-server.html
server_name has a maximum length of 64 characters (names longer than 64 characters are silently truncated), and is case-insensitive. Character literals are UTF-8, support a maximum length of 64 characters and default to a blank (empty) string.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-restrictions.html
The Performance Schema avoids using mutexes to collect or produce data, so there are no guarantees of consistency and results can sometimes be incorrect. If the values in this table for a given timer name are NULL, that timer is not supported on ...