How to view mysql using cmd

cmd method to view mysql: first enter the database through cmd; then execute the command "show databases;" to display all databases; then select the database through the command "use xxx;"; finally execute the command "select * from tbl_dept;"Display table data.

Recommendation: "mysql video tutorial"

1. cmd to enter the database, mysql -u root -p Press Enter and enter the password;

##2. Display all databases. show databases;

3. Select the database, use xxx;

4 . Display table. show tables;

5 . Direct query statement to display table data. select * from tbl_dept;

============================ Gorgeous dividing line ===========================

The above is the detailed content of How to view mysql using cmd. For more information, please follow other related articles on the PHP Chinese website!