Commands for how to view a database

Editor to share with you how to view the database command, I believe that most people do not know much about it, so share this article for you to learn, I hope you will learn a lot after reading this article, let's go to learn the method!

The command to view the database is: [show databases], which can view all databases. If we want to view the tables in the database, we can use the command [show tables]. If you enter the wrong command, you can end it with [\ c].

To view databases, you can use the show databases command, which can view all databases, which is equivalent to the following command

(recommended tutorial: mysql tutorial)

Select schema_name from information_schema.schemata\ G

Related introduction:

Use the use command to select a database such as use information_schema, when using this command

Select schema_name from information_schema.schemata\ G

Can be used for

Select schema_name from schemata\ G

If you want to view tables in the database, you can use the command

Show tables

You can also see it in information_schema, where the show command is a short mode that is easy to use.

Select table_name from tables where table_schema='jblog'

If you want to view the table structure, you can use the command

Desc table_name

If you want to view the table status, you can use the command

Show table status from db like condition

Tip: when you enter a multi-line command and find an error, you can end it with\ c.

The above is how to view all the contents of the database command, thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!