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/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.0/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.0/en/solaris-installation-pkg.html
You must have root privileges to perform this operation: $> pkgadd -d mysql-8.0.44-solaris11-x86_64.pkg The following packages are available: 1 mysql MySQL Community Server (GPL) (i86pc) 8.0.44 Select package(s) you wish to process (or 'all' to ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/structured-system-variables.html
For example, to set a key cache named hot_cache to a size of 10MB, use either of these statements: mysql> SET GLOBAL hot_cache.key_buffer_size = 10*1024*1024; mysql> SET @@GLOBAL.hot_cache.key_buffer_size = 10*1024*1024; To retrieve the cache size, ... A structured variable differs from a regular system variable in two respects: Its value is a structure with components that specify server parameters considered to be closely ...
https://dev.mysql.com/doc/refman/8.0/en/sys-execute-prepared-stmt.html
Example mysql> CALL sys.execute_prepared_stmt('SELECT COUNT(*) FROM mysql.user'); +----------+ | COUNT(*) | +----------+ | 15 | +----------+ . Given an SQL statement as a string, executes it as a prepared statement. The prepared statement is ...
https://dev.mysql.com/doc/refman/8.0/en/sys-extract-schema-from-file-name.html
Example mysql> SELECT sys.extract_schema_from_file_name('/usr/local/mysql/data/world/City.ibd'); +---------------------------------------------------------------------------+ | ... Given a file path name, returns the path component that represents ...
https://dev.mysql.com/doc/refman/8.0/en/sys-extract-table-from-file-name.html
Example mysql> SELECT sys.extract_table_from_file_name('/usr/local/mysql/data/world/City.ibd'); +--------------------------------------------------------------------------+ | sys.extract_table_from_file_name('/usr/local/mysql/data/world/City.ibd') | ... Given a file path name, returns the path component that represents the table ...