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/show-databases.html
Caution Because a global privilege is considered a privilege for all databases, any global privilege enables a user to see all database names with SHOW DATABASES or by examining the INFORMATION_SCHEMA SCHEMATA table. SHOW {DATABASES | SCHEMAS} ...
https://dev.mysql.com/doc/refman/5.7/en/show-events.html
In its simplest form, SHOW EVENTS lists all of the events in the current schema: mysql> SELECT CURRENT_USER(), SCHEMA(); +----------------+----------+ | CURRENT_USER() | SCHEMA() | +----------------+----------+ | jon@ghidora | myschema | ... SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 25.19.1, “Query Profiling Using Performance Schema”. To control profiling, ...
https://dev.mysql.com/doc/refman/5.7/en/show-relaylog-events.html
Note Some events relating to the setting of user and system variables are not included in the output from SHOW RELAYLOG EVENTS. SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] [channel_option] channel_option: FOR CHANNEL ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html
Master_User The user name of the account used to connect to the source. SHOW SLAVE STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica threads. If you issue this statement using the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 10:10:12.61 sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-function-argument-handling.html
This provides additional flexibility to users because it is unnecessary to be concerned about the uniqueness of geometry data. Spatial values, or geometries, have the properties described in Section 11.4.2.2, “Geometry Class”. Specific ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
(See also Bug #16522.) Each execution of the statements contained in the body of an event takes place in a new connection; thus, these statements have no effect in a given user session on the server's statement counts such as Com_select and ...Some ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-variables.html
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 DECLARE to define local variables, and stored routines (procedures and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-diagnostics.html
Configuration Options diagnostics() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 26.4.2.1, “The sys_config Table”): debug, @sys.debug If this option is ON, produce ... Creates a report of the current server status for diagnostic ...