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/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-stored-procs.html
You can manage stored procedures with CREATE [FUNCTION|PROCEDURE], ALTER [FUNCTION|PROCEDURE], DROP [FUNCTION|PROCEDURE], and SHOW CREATE [FUNCTION|PROCEDURE]. You can obtain information about existing stored procedures using the ROUTINES table in ...Where can I find documentation for MySQL stored procedures and stored functions? ...
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. If the set of columns in the table is modified with ALTER TABLE, the prepared statement goes ...Table content changes (for example, with INSERT or UPDATE) do not change metadata, nor do SELECT ... For certain statements that a client might execute multiple times during a session, the server ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-foreign-keys.html
If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it has previously updated during the same cascade, it acts like RESTRICT. The MATCH clause in the SQL standard controls how NULL values in a composite (multiple-column) ...
https://dev.mysql.com/doc/refman/5.7/en/concurrent-inserts.html
If the variable is set to ALWAYS (or 2), concurrent inserts at the end of the table are permitted even for tables that have deleted rows. This is done to ensure that you can re-create an exact copy of your tables by applying the log during a backup ...If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
Support for aliases on tables and columns as required by standard SQL. Support for MySQL-specific SHOW statements that retrieve information about databases, storage engines, tables, and indexes. You can refer to tables from different databases in ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-identifying.html
If you enable a different file format using the innodb_file_format configuration option, the change only applies to newly created tables. Also, when you create a new table, the tablespace containing the table is tagged with the “earliest” or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html
The data files that you define in the configuration file using the innodb_data_file_path configuration option form the InnoDB system tablespace. You cannot define where within the system tablespace your tables are allocated. In a newly created ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-database-objects.html
Some database objects such as tables and indexes have different limitations when using the NDBCLUSTER storage engine: Database and table names. When using the NDB storage engine, the maximum allowed length both for database names and for table ...
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
Whether the optimizer actually does so depends on whether reading the index is more efficient than a table scan if columns not in the index must also be read. In that case, scanning an entire index and looking up table rows to find columns not in ...