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;
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!