What all does the SHOW statement do in MySQLSolutionAs the c

What all does the SHOW statement do in MySQL?

Solution

As the command term itself is SHOW says its used to show data , like show information about tables, database ,columns or status information about commands. There are many version to it :

SHOW:

1) BINARY LOGS

2) BINLOG EVENTS

3) CHARACTER SET

4) COLLATION

5) COLUMNS

6) CREATE DATABASE

7) CREATE EVENTS

8) CREATE FUNCTION

9) CREATE PROCEDURE

10) CREATE TABLE

11) CREATE VIEW

12) DATABASE

13) ENGINE

14) TABLES

15) TRIGGERS

16) VARIABLES

17) WARNINGS

18) STATUS

19) EVENTS

20) ERRORS