In this tutorial, I am going to explain about the MySQL Help and Show Commands with examples.
In MySQL, we have to use many commands. Some commands are used to show statements. These commands provide general information related to our database. The output from the show table contains a column of table names. This statement lists any views in the database.
Below are some examples of help and show command with syntax that provide general information of our database and tables.
SHOW STATEMENTS
1) USE <database_name>;
2) Show databases list the databases name in MySQL.
Syntax:
b)
- SHOW DATABASES LIKE '%dml%';
3) SHOW TABLES FROM <database_name> LIKE <table_name>;
4) Show Tables lists the NON-TEMPORARY tables name from a given database.
Syntax:
5)
- USE order_by;
-
- SHOW COLUMNS FROM <table_name>;
DESCRIBE
In MySQL, the describe command shows table functionality.
Syntax:
DESCRIBE <table_name>;
1)
- SELECT USER(), NOW(), VERSION(), DATABASE();
2)
- SHOW GRANTS FOR root@localhost;
3)
- SHOW INDEX FROM emp_info;
4)
- SHOW INDEX FROM emp_info FROM vatsa;
In MySQL, the Status command is used to get the status information from the server.
2) SHOW TABLE STATUS FROM <database_name>;
Show variables show the values of MySQL system variables. Show variable displays the values that are used for new connections to MySQL.
Syntax:
In this article, I have discussed the concept of MySQL Help and Show Commands with various examples.
I hope you enjoyed this article. Follow C# Corner to learn more new and amazing things about MySQL.
Thanks for reading this article!