PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-features-functions.html
(See Section 16.2.1, “Replication Formats”.) USER() and CURRENT_USER() are automatically replicated using row-based replication when using MIXED mode, and generate a warning in STATEMENT mode. SYSDATE() is automatically replicated using ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-enable-gtids.html
If this step causes any warnings in the log, adjust your application so that it only uses GTID-compatible features and does not generate any warnings. You must ensure that no warnings are being generated in the error logs before going to the next ...
https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html
If an application generates a query such as SELECT * FROM table WHERE ID=234 when a user enters the value 234, the user can enter the value 234 OR 1=1 to cause the application to generate the query SELECT * FROM table WHERE ID=234 OR 1=1. Your ...
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
MySQL servers compiled using OpenSSL can generate missing certificate and key files automatically at startup. (The files need not have been generated automatically; what matters is that they have those names and are valid.) If the server does not ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
When all tables are processed, MySQL outputs the selected columns and backtracks through the table list until a table is found for which there are more matching rows. Also, for SELECT statements, EXPLAIN generates extended information that can be ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-wait-summary-tables.html
The following sections describe the table I/O and lock wait summary tables: table_io_waits_summary_by_index_usage: Table I/O waits per index table_io_waits_summary_by_table: Table I/O waits per table table_lock_waits_summary_by_table: Table lock ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
A generated column in a view is considered updatable because it is possible to assign to it. For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. For example, if a view is defined as SELECT * on a ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
If you store values larger than the display width in an integer column that has the ZEROFILL attribute, you may experience problems when MySQL generates temporary tables for some complicated joins. Inserting NULL to generate AUTO_INCREMENT values ...
https://dev.mysql.com/doc/refman/5.7/en/view-updatability.html
For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. However, if such a column is updated explicitly, the only permitted value is DEFAULT. Also, only a single table in the view definition can be ... Some views are updatable and references to them can be used to specify tables to be updated in data change ...
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
CHECK TABLE supports secondary indexes on virtual generated columns, which are supported by InnoDB. CHECK TABLE Output Checking Version Compatibility Checking Data Consistency CHECK TABLE Usage Notes for InnoDB Tables CHECK TABLE Usage Notes for ...