3. Display all tables in the database show"/> 3. Display all tables in the database show">
Home > Article > System Tutorial > Detailed method of using MySQL in Linux environment
The article is based on the UI part of the system designed using the django framework using Python. There are some places where mysql is used. MySQL is not commonly used in this case, so some simple usage records are recorded here to prevent forgetting
First start mysql, note "mysqld
"
systemctl start mysqld
Then enter:
mysql -u root -p
Then enter the password.
show databases;
For example, I checked all databases:
use <database-name>
show tables
describe <table-name>
drop <database-name>
drop <table-name> <font face="Tahoma"><span style="white-space: normal;"> </span></font>
The above is the detailed content of Detailed method of using MySQL in Linux environment. For more information, please follow other related articles on the PHP Chinese website!