Shulou(Shulou.com)06/01 Report--

How to view mysql database building statements under cmd? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

The method to view the mysql database building statement under cmd is as follows: first, open and run, enter the [mysql-uroot-p] command to enter mysql;, then execute the show database command to view the current database; finally, execute show create database xxx to view the database building statement.

How to view the mysql database building statement under cmd:

1. Press win+R to open and run, and enter cmd to enter, as shown in the following figure

2. Enter the mysql-uroot-p command to enter mysql, as shown in the following figure

3. Execute show database; command to view the current database, as shown in the following figure

4. Then execute show create database xxx to view the database building statement, as shown in the following figure

5. When you execute the show create command after the database is selected, you can also see the database building statement, as shown in the following figure

6. Finally, you can also view the database-building statements of other databases in the selected database, as shown in the following figure

Thank you for reading! After reading the above, do you have a general understanding of the method of viewing mysql database building statements under cmd? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.