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/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-before-you-begin.html
Note The downgrade procedures described in the following sections assume you are downgrading with data files created or modified by the newer MySQL version. The backup should include the mysql database, which contains the MySQL system tables. Review ...
https://dev.mysql.com/doc/refman/5.7/en/drop-procedure.html
(If the automatic_sp_privileges system variable is enabled, that privilege and EXECUTE are granted automatically to the routine creator when the routine is created and dropped from the creator when the routine is dropped. DROP {PROCEDURE | ...
https://dev.mysql.com/doc/refman/5.7/en/drop-table.html
A TEMPORARY table is visible only with the session that created it, so no check is necessary. Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the ...
https://dev.mysql.com/doc/refman/5.7/en/engine-condition-pushdown-optimization.html
This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to the storage engine for evaluation. This optimization can be used only by the NDB ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption.html
Note MySQL Enterprise Encryption is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes a set of encryption functions based on the OpenSSL library that expose OpenSSL capabilities at the SQL ...
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler-thread-states.html
These states occur for the Event Scheduler thread, threads that are created to execute scheduled events, or threads that terminate the scheduler. Clearing The scheduler thread or a thread that was executing an event is terminating and is about to ...
https://dev.mysql.com/doc/refman/5.7/en/explain.html
The SHOW CREATE TABLE, SHOW TABLE STATUS, and SHOW INDEX statements also provide information about tables. In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-storage-engines.html
The disabled_storage_engines configuration option defines which storage engines cannot be used to create tables or tablespaces. Where can I obtain complete documentation for MySQL storage engines? A.2.2. Can I prevent the use of a particular storage ...
https://dev.mysql.com/doc/refman/5.7/en/fetching-spatial-data.html
Fetching spatial data in internal format: Fetching geometry values using internal format can be useful in table-to-table transfers: CREATE TABLE geom2 (g GEOMETRY) SELECT g FROM geom; Fetching spatial data in WKT format: The ST_AsText() function ...