PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-grants.html
SHOW GRANTS requires the SELECT privilege for the mysql system database, except to display privileges for the current user. SHOW GRANTS [FOR user] This statement displays the privileges that are assigned to a MySQL user account, in the form of ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-status.html
To use either statement, you must be the owner of the routine or have SELECT access to the mysql.proc table. The WHERE clause can be given to select rows using more general conditions, as discussed in Section 24.8, “Extensions to SHOW ... SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/show-profile.html
For example, the following queries are equivalent: SHOW PROFILE FOR QUERY 2; SELECT STATE, FORMAT(DURATION, 6) AS DURATION FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID = 2 ORDER BY SEQ; . Note The SHOW PROFILE and SHOW PROFILES statements are ...
https://dev.mysql.com/doc/refman/5.7/en/show-relaylog-events.html
The LIMIT clause has the same syntax as for the SELECT statement. SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] [channel_option] channel_option: FOR CHANNEL channel Shows the events in the relay log of a replica. If ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-geojson-functions.html
mysql> SELECT ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2); +-------------------------------------------------------------+ | ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2) | ... This section describes functions for ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions-object-shapes.html
mysql> SET @g1 = Point(1,1); mysql> SET @g2 = Point(2,2); mysql> SELECT ST_Distance(@g1, @g2); +-----------------------+ | ST_Distance(@g1, @g2) | +-----------------------+ | 1.4142135623730951 | +-----------------------+ ST_Distance() and ... The ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-variables.html
Results from queries can be retrieved into local variables using SELECT ... System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program context. In addition, stored programs can use ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html
Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement made up of several statements separated by semicolon (;) characters. For example, the following stored procedure has a body made up of ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-syntax.html
MySQL supports a very useful extension that enables the use of regular SELECT statements (that is, without using cursors or local variables) inside a stored procedure. Multiple SELECT statements generate multiple result sets, so the client must use ... A stored routine is either a procedure or a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-instrument-default-enabled.html
Example mysql> SELECT sys.ps_is_instrument_default_enabled('memory/innodb/row_log_buf'); +-------------------------------------------------------------------+ | sys.ps_is_instrument_default_enabled('memory/innodb/row_log_buf') | ... Returns YES or ...