Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-code.html
To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, or have the SELECT privilege at the global level. SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only ...
https://dev.mysql.com/doc/refman/8.4/en/show-status.html
A WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern' | WHERE expr] SHOW STATUS provides server status information ...
https://dev.mysql.com/doc/refman/8.4/en/show-tables.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. SHOW [EXTENDED] [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the ...
https://dev.mysql.com/doc/refman/8.4/en/show-triggers.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers ...
https://dev.mysql.com/doc/refman/8.4/en/show.html
Many MySQL APIs (such as PHP) enable you to treat the result returned from a SHOW statement as you would a result set from a SELECT; see Chapter 31, Connectors and APIs, or your API documentation for more information. SHOW has many forms that ...
https://dev.mysql.com/doc/refman/8.4/en/socket-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%socket%'; +-------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +-------------+---------------+ | auth_socket | ACTIVE | ... The ...
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation-pkg.html
You must have root privileges to perform this operation: $> pkgadd -d mysql-8.4.6-solaris11-x86_64.pkg The following packages are available: 1 mysql MySQL Community Server (GPL) (i86pc) 8.4.6 Select package(s) you wish to process (or 'all' to ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-index-optimization.html
To determine the SRIDs contained in a geometry column col_name, use the following query: SELECT DISTINCT ST_SRID(col_name) FROM tbl_name; If the query returns more than one row, the column contains a mix of SRIDs. MySQL permits creation of SPATIAL ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-reference-systems.html
The following example shows what an SRS entry looks like: mysql> SELECT * FROM INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID = 4326\G *************************** 1. A spatial reference system (SRS) for spatial data is a ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-privileges.html
For an account other than the account named as the routine DEFINER, access to routine properties depends on the privileges granted to the account: With the SHOW_ROUTINE privilege or the global SELECT privilege, the account can see all routine ...