MySQL commonly used database management commands

MySQL database is an open source relational database management system. The MySQL database system uses the most commonly used database management language--Structured Query Language (SQL) for database management. MySQL database management has its own unique commands. The following introduces you to the commonly used commands for MySQL database management.

MySQL databaseThe management of the database is a vital link. If you want to understand the management of the MySQL database, you must start from the basics. Only by first knowing the tools used in database management command, it is much easier to operate in practice. The following are MySQL database managementcommon commands:

1. InstallationUse the RPM package to install Mysql and set iptables for TCP 3306 port.

2. root password management Set the password of the root user mysqladmin -uroot password 'password'.

3. Change the password of the root user mysqladmin -uroot -p password 'password'.

4. Database and table management enter mysqlmysql -h hostname -uroot -p.

5. Create databasemysql> create database location.

6. Import data structure mysql -uroot -p location <./location.sql.

7. View database mysql> show databases;

8. Enter a database mysql> use location;

9. View table information mysql> show tables;

10. View table structure mysql> desc Contact;

11. Rename the table mysql> rename table Contact to Contact_new.

12. Delete library mysql> drop database location.

13. Delete table mysql> drop table Contact.

14. Authorization section creates the user and authorizes mysql> grant all on location.* to gk1020@'10.1.11.71' identified by 'gk1020'.

15. Cancel authorization mysql> revoke all on location.* from gk1020@'10.1.11.71'.

16. Refresh privileges mysql> flush privileges.

17. Operation statement query mysql> select * from Contact.

18. mysql> select count(*) from Contact.

19. Modify mysql> update Contact set RegTime=‘2008-01-01 00:00:00’ where id=1.

20. mysql> update Contact set RegTime=‘2008-01-01 00:00:00’,CID=1 where id=1.

21. insert mysql> insert into Contact values('',''...)

22. mysql> insert into Contact(ID,CID,Contact ) values('',''...)

23. Delete mysql> delete from Contact where id=1.

24. Export export database locationmysqldump -uroot -p location >./location.sql.

25. Export a table mysqldump -uroot -p --database location --table Contact >./contact.sql.

26. Export the data structure of the database location mysqldump -d -uroot -p location >./location.sql.

27. Copy table Copy table Contact as Contact_bakmysql> create table Contact_bak as select * from Contact.

28. Copy the structure of table Contact mysql> create table Contact_bak as select * from Contact where 1=2.

29. View the tasks being executed mysql> show processlist.

Special note:

location is the library name, Contact is the table name

Let’s understand these MySQL database management Commonly used commands, applied in actual operations, and mastered proficiently, then MySQL database management common commands will be a piece of cake.

The above is the detailed content of MySQL commonly used database management commands. For more information, please follow other related articles on the PHP Chinese website!