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;

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!