PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/show-create-user.html
row *************************** CREATE USER for u1@localhost: CREATE USER `u1`@`localhost` IDENTIFIED WITH 'caching_sha2_password' AS ... SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named user. The statement ...
https://dev.mysql.com/doc/refman/8.0/en/show-databases.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 {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr] SHOW DATABASES lists the databases on the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/show-open-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 OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/show.html
Several SHOW statements also accept a WHERE clause that provides more flexibility in specifying which rows to display. SHOW has many forms that provide information about databases, tables, columns, or status information about the server. The ...
https://dev.mysql.com/doc/refman/8.0/en/signal.html
SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the error's characteristics (error number, SQLSTATE value, message). Without SIGNAL, it is necessary to resort ...
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
If the names do not match, the plugin checks whether the socket user name matches the name specified in the authentication_string column of the mysql.user system table row. The server-side auth_socket authentication plugin authenticates clients ...
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
row *************************** SRS_NAME: WGS 84 SRS_ID: 4326 ORGANIZATION: EPSG ORGANIZATION_COORDSYS_ID: 4326 DEFINITION: GEOGCS["WGS 84",DATUM["World Geodetic System 1984", SPHEROID["WGS 84",6378137,298.257223563, ... A spatial reference system ...
https://dev.mysql.com/doc/refman/8.0/en/stop-replica.html
When the source is using the row-based binary logging format, you should execute STOP REPLICA or STOP REPLICA SQL_THREAD on the replica prior to shutting down the replica server if you are replicating any tables that use a nontransactional storage ...] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication ...