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/fetch.html
This statement fetches the next row for the SELECT statement associated with the specified cursor (which must be open), and advances the cursor pointer. The number of columns retrieved by the SELECT statement must match the number of output ...If a ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/function-resolution.html
For example, either of the following function calls are legal: SELECT COUNT(*) FROM mytable; SELECT COUNT (*) FROM mytable; However, enabling IGNORE_SPACE also has the side effect that the parser treats the affected function names as reserved words ... MySQL supports built-in (native) functions, loadable functions, and stored ...
https://dev.mysql.com/doc/refman/5.7/en/getting-information.html
To find out which database is currently selected, use the DATABASE() function: mysql> SELECT DATABASE(); +------------+ | DATABASE() | +------------+ | menagerie | +------------+ If you have not yet selected any database, the result is NULL. What ...
https://dev.mysql.com/doc/refman/5.7/en/gis-format-conversion-functions.html
SELECT ST_AsBinary(g) FROM geom; ST_AsBinary(), ST_AsWKB(), AsBinary(), and AsWKB() are synonyms. mysql> SET @g = 'LineString(1 1,2 2,3 3)'; mysql> SELECT ST_AsText(ST_GeomFromText(@g)); +--------------------------------+ | ... MySQL supports the ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
The mysql system database includes several grant tables that contain information about user accounts and the privileges held by them. For information about other tables in the system database, see Section 5.3, “The mysql System Database”. The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-trx-table.html
To resolve a deadlock, InnoDB selects the transaction with the smallest weight as the “victim” to roll back. TRX_AUTOCOMMIT_NON_LOCKING A value of 1 indicates the transaction is a SELECT statement that does not use the FOR UPDATE or LOCK IN ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-state-table.html
This is the same as MAX(TP_THREAD_NUMBER) for the threads when selected from the TP_THREAD_STATE table. That is, these two queries are equivalent: SELECT TP_GROUP_ID, MAX_THREAD_IDS_IN_GROUP FROM TP_THREAD_GROUP_STATE; SELECT TP_GROUP_ID, ... The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'keyring%'; +--------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +--------------+---------------+ | keyring_file | ACTIVE | ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks.html
A deadlock can occur when transactions lock rows in multiple tables (through statements such as UPDATE or SELECT ... FOR UPDATE) in each transaction; create indexes on the columns used in SELECT ... A deadlock is a situation in which multiple ...