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-data.html
Unless REPLACE is also specified, LOCAL has the same effect as the IGNORE modifier on the interpretation of input file contents and error handling; see Duplicate-Key and Error Handling, and Column Value Assignment. For example, if mysqld was started ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers created in MySQL 5.7.2 or later, NULL for triggers created prior to 5.7.2. row *************************** Trigger: ins_sum Event: INSERT Table: account ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL ...It ...
https://dev.mysql.com/doc/refman/5.7/en/option-modifiers.html
For example, with --maximum-back_log=200, the server produces this error: Maximum value of 'back_log' cannot be set . The --maximum prefix is available for mysqld only and permits a limit to be placed on how large client programs can set session ...
https://dev.mysql.com/doc/refman/5.7/en/expired-password-handling.html
For any operation not permitted within the session, the server returns an ER_MUST_CHANGE_PASSWORD error: mysql> USE performance_schema; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. If ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
Prepared statements that are issued using the binary protocol using mysql_stmt_prepare() and mysql_stmt_execute() (see C API Prepared Statement Interface), are subject to limitations on caching. The statement is compared only with other cached ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-trx-info.html
The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and events_statements_history tables. Configuration Options ps_thread_trx_info() operation ... Returns a JSON object containing information about a given ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-enable-gtids.html
The following procedure can be paused at any time and later resumed where it was, or reversed by jumping to the corresponding step of Section 16.1.4.3, “Disabling GTID Transactions Online”, the online procedure to disable GTIDs. To enable GTID ... This section describes how to enable GTID transactions, and optionally auto-positioning, on servers that are already online and using anonymous ...
https://dev.mysql.com/doc/refman/5.7/en/using-date.html
MySQL also permits a “relaxed” string format when updating and in a WHERE clause that compares a date to a DATE, DATETIME, or TIMESTAMP column. When you compare a DATE, TIME, DATETIME, or TIMESTAMP to a constant string with the <, <=, =, >=, >, ...You should use this format in UPDATE expressions and in the WHERE clause of SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-generated-columns.html
Adding or dropping a secondary index on a virtual generated column is an in-place operation. For more information, see Section 13.1.18.8, “Secondary Indexes and Generated Columns”. However, later reads from the table might report warnings or ...