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/update.html
Multiple-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_references SET assignment_list [WHERE where_condition] For the single-table syntax, the UPDATE statement updates columns of existing rows in the named table with new values. UPDATE is a ...
https://dev.mysql.com/doc/refman/5.7/en/what-is-mysql.html
The SQL standard has been evolving since 1986 and several versions exist. MySQL Server was originally developed to handle large databases much faster than existing solutions and has been successfully used in highly demanding production environments ... MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle ...
https://dev.mysql.com/doc/refman/5.7/en/xa-restrictions.html
Similarly, an XA transaction that was in PREPARED state would still exist in PREPARED state in case the server was shutdown abnormally and then started again, but the contents of the transaction could not be written to the binary log. The following ... XA transaction support is limited to the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-unicode-uca.html
Instead, you begin with an existing “base” collation and describe the new collation in terms of how it differs from the base collation. This section describes how to add a UCA collation for a Unicode character set by writing the <collation> ...
https://dev.mysql.com/doc/refman/5.7/en/alter-logfile-group.html
ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group logfile_group. An ALTER LOGFILE GROUP statement has ...
https://dev.mysql.com/doc/refman/5.7/en/alter-view.html
ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER }] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] CHECK OPTION] This statement changes the definition of a view, ...
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
The ARCHIVE engine also supports the AUTO_INCREMENT table option in CREATE TABLE statements to specify the initial sequence value for a new table or reset the sequence value for an existing table, respectively. The ARCHIVE storage engine produces ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-legacy-filtering.html
Modifications to audit_log_include_accounts or audit_log_exclude_accounts affect only connections created subsequent to the modification, not existing connections. Note This section describes legacy audit log filtering, which applies under either ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-security.html
By default, contents of audit log files produced by the audit log plugin are not encrypted and may contain sensitive information, such as the text of SQL statements. For security reasons, audit log files should be written to a directory accessible ...
https://dev.mysql.com/doc/refman/5.7/en/batch-mode.html
You can generate new queries from existing ones that are similar by copying and editing script files. In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some ...