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-open-tables.html
SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table cache. The FROM clause, if present, restricts the tables shown to those present in the db_name ...The LIKE clause, if present, indicates which table names to ...
https://dev.mysql.com/doc/refman/5.7/en/show-plugins.html
SHOW PLUGINS output has these columns: Name The name used to refer to the plugin in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN. For information about plugin data structures that form the basis of the information displayed by SHOW ...row ...
https://dev.mysql.com/doc/refman/5.7/en/show-privileges.html
SHOW PRIVILEGES SHOW PRIVILEGES shows the list of system privileges that the MySQL server supports. Privileges belonging to a specific user are displayed by the SHOW GRANTS statement. The exact list of privileges depends on the version of your ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-status.html
SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr] This statement is a MySQL extension. A similar statement, SHOW FUNCTION STATUS, displays information about stored functions (see Section 13.7.5.20, “SHOW FUNCTION STATUS Statement”). The WHERE ...It returns characteristics of a stored procedure, such as the database, name, type, creator, creation and modification dates, and character set ...
https://dev.mysql.com/doc/refman/5.7/en/show-profiles.html
SHOW PROFILES The SHOW PROFILES statement, together with SHOW PROFILE, displays profiling information that indicates resource usage for statements executed during the course of the current session. Note The SHOW PROFILE and SHOW PROFILES statements ...Use the Performance Schema instead; see Section 25.19.1, “Query Profiling Using Performance ...
https://dev.mysql.com/doc/refman/5.7/en/show-tables.html
SHOW [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a given database. You can also get this list using the mysqlshow db_name command. The WHERE clause can be given to select rows ...
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default database unless a FROM clause is given). The WHERE clause can be given to select rows using ...This statement returns results only for databases and tables for which you have the TRIGGER ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html
SHOW CREATE PROCEDURE proc_name This statement is a MySQL extension. A similar statement, SHOW CREATE FUNCTION, displays information about stored functions (see Section 13.7.5.8, “SHOW CREATE FUNCTION Statement”). row ...It returns the exact ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-user.html
SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named user. To display the privileges granted to an account, use the SHOW GRANTS statement. The statement requires the SELECT privilege for the mysql system ...
https://dev.mysql.com/doc/refman/5.7/en/show-engines.html
SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage engines. row *************************** Engine: FEDERATED Support: YES Comment: Federated MySQL storage engine Transactions: NO XA: NO Savepoints: NO The ...