PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/federated-description.html
When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated data. When you create a FEDERATED table, the table definition is the same, but the ...
https://dev.mysql.com/doc/refman/5.7/en/insert-select.html
SELECT, you can quickly insert many rows into a table from the result of a SELECT statement, which can select from one or many tables. The target table of the INSERT statement may appear in the FROM clause of the SELECT part of the query. However, ... INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
For the reasons for this, see Section 13.2.5.3, “INSERT DELAYED Statement”, Inserting into a table requires the INSERT privilege for the table. When inserting into a partitioned table, you can control which partitions and subpartitions accept ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
The copy of the normalized statement digest is stored in the appropriate Performance Schema tables, along with the MD5 hash value computed from the original normalized statement. Statement Digests in the Performance Schema In the Performance Schema, ... The MySQL server is capable of maintaining statement digest ...
https://dev.mysql.com/doc/refman/5.7/en/plugin-loading.html
Alternatively, the INSTALL PLUGIN statement causes the server to load the plugin code from the library file at runtime: INSTALL PLUGIN myplugin SONAME 'somepluglib.so'; INSTALL PLUGIN also causes “permanent” plugin registration: The plugin is ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html
As noted in Section 16.4.1.29, “Replication and Temporary Tables”, temporary tables are not replicated when using row-based format. When using mixed format logging, “safe” statements involving temporary tables are logged using ... MySQL uses ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-conversion.html
Tables can be converted from utf8mb3 to utf8mb4 by using ALTER TABLE. Otherwise, you should be able to convert your tables from utf8mb3 to utf8mb4 without problems, using ALTER TABLE as described previously. The exception is that in table ... This ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
Prepared Statements in SQL Scripts An alternative SQL interface to prepared statements is available. Metadata changes to tables or views referred to by prepared statements are detected and cause automatic repreparation of the statement when it is ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). Statements that affect mysql database tables are written to the binary log ...Statements that change the mysql database indirectly are logged as statements regardless of the value of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl.html
The online DDL feature provides support for in-place table alterations and concurrent DML. You can control aspects of a DDL operation using the ALGORITHM and LOCK clauses of the ALTER TABLE statement. For example: ALTER TABLE tbl_name ADD PRIMARY ...Benefits of this feature include: Improved responsiveness and availability in busy production environments, where making a table unavailable for minutes or hours is not ...