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/partitioning-management-range-list.html
SELECT ..., then drop the old table and rename the new one, but this could be very time-consuming when dealing with a large amounts of data. You also cannot use this statement to change the partitioning expression or column. Adding and dropping of ...
https://dev.mysql.com/doc/refman/5.7/en/statement-caching.html
Metadata changes occur for DDL statements such as those that create, drop, alter, rename, or truncate tables, or that analyze, optimize, or repair tables. Suppose that a client prepares this statement: PREPARE s1 FROM 'SELECT * FROM t1'; The SELECT ... For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal structure and caches that structure to be used during ...
https://dev.mysql.com/doc/refman/5.7/en/function-resolution.html
When the parser encounters a word that is the name of a built-in function, it must determine whether the name signifies a function call or is instead a nonexpression reference to an identifier such as a table or column name. If a new version of ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-changes.html
A grant table reload affects privileges for each existing client session as follows: Table and column privilege changes take effect with the client's next request. If the mysqld server is started without the --skip-grant-tables option, it reads all ...
https://dev.mysql.com/doc/refman/5.7/en/show-open-tables.html
SHOW OPEN TABLES output has these columns: Database The database containing the table. Name locking is used for operations such as dropping or renaming tables. SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-reading.html
The plugin ignores files that have been renamed manually and do not match the pattern, and files that were encrypted with a password no longer available in the keyring. The audit log plugin supports functions that provide an SQL interface for ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mysql-database.html
This pertains to statements such as GRANT, REVOKE, SET PASSWORD, RENAME USER, CREATE (all forms except CREATE TABLE ... The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
In this case, remove or rename the data directory and try again. After MySQL is installed, the data directory must be initialized, including the tables in the mysql system database: For some MySQL installation methods, data directory initialization ...
https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html
Once this limit is exceeded, you must rename or remove the file before it is possible to execute any additional DDL statements. The DDL log, or metadata log, records metadata operations generated by data definition statements affecting table ...
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
This function was renamed to JSON_ARRAY_APPEND() in MySQL 5.7.9; the alias JSON_APPEND() is now deprecated in MySQL 5.7, and is removed in MySQL 8.0. The functions in this section modify JSON values and return the result. JSON_APPEND(json_doc, ...