PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/describe.html
The DESCRIBE and EXPLAIN statements are synonyms, used either to obtain information about table structure or query execution plans. For more information, see Section 15.7.7.5, “SHOW COLUMNS Statement”, and Section 15.8.2, “EXPLAIN ...
https://dev.mysql.com/doc/refman/8.0/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. DO is useful primarily with functions that have side effects, such as RELEASE_LOCK(). It cannot be used ...
https://dev.mysql.com/doc/refman/8.0/en/document-store-concepts.html
In terms of MySQL this means: Create a new document (insertion or addition) Read one or more documents (queries) Update one or more documents Delete one or more documents . This section explains the concepts introduced as part of using MySQL as a ...
https://dev.mysql.com/doc/refman/8.0/en/document-store-interfaces.html
You can use MySQL Shell to prototype applications, execute queries and update data. To work with MySQL as a document store, you use dedicated components and a choice of clients that support communicating with the MySQL server to develop document ...
https://dev.mysql.com/doc/refman/8.0/en/drop-spatial-reference-system.html
DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid srid: 32-bit unsigned integer This statement removes a spatial reference system (SRS) definition from the data dictionary. Example: DROP SPATIAL REFERENCE SYSTEM 4120; If no SRS definition with the ...
https://dev.mysql.com/doc/refman/8.0/en/error-log.html
Depending on error log configuration, error messages may also populate the Performance Schema error_log table, to provide an SQL interface to the log and enable its contents to be queried. This section discusses how to configure the MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/events-metadata.html
To obtain metadata about events: Query the EVENTS table of the INFORMATION_SCHEMA database. Event Scheduler Time Representation Each session in MySQL has a session time zone (STZ). This is the session time_zone value that is initialized from the ...
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system variable. The EVENT privilege governs the creation, modification, and deletion of events. For example, suppose that ...
https://dev.mysql.com/doc/refman/8.0/en/example-storage-engine.html
The EXAMPLE storage engine is a stub engine that does nothing. Its purpose is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. To enable the EXAMPLE storage engine if you build MySQL from ...
https://dev.mysql.com/doc/refman/8.0/en/exists-and-not-exists-subqueries.html
If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. For example: SELECT column1 FROM t1 WHERE EXISTS (SELECT * FROM t2); Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with ...