Practical Analysis of MySQL basic Command

This article mainly introduces "practical analysis of MySQL basic commands". In daily operation, I believe that many people have doubts about the practical analysis of MySQL basic commands. The editor has consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubts of "practical analysis of MySQL basic commands". Next, please follow the editor to study!

Start the mysql service

(run cmd as administrator)

Net start mysql

Connect mysql

Mysql-u root-p

Common command Database

View the library

Show databases

Create a library

Create database database_name

Use the library

Use database_name

View currently used libraries

Select database ()

Table

Create a tabl

Create table table_name (column name data type, column name data type)

View tabl

Show tables

View table structure

Desc table_name

View the detailed definition of the table

Show create table table_name

At this point, the study of "practical Analysis of MySQL basic commands" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!