Introduction to simple operation commands of MYSQL

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

1. Log in to mysql

Mysql-u root-p

two。 Query which users can log in to mysql

Mysql > select host,user from user

3. Change column name (oracle seems to be unable to change column name)

Alter table [test] change [old_column_name] [new_column_name] tinytext

4. Modify permissions

Mysql > flush privileges

At this point, the study of "introduction to simple operating commands of MYSQL" 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!