What are the commonly used commands in MySQL?

This article will introduce you to the common commands of MySQL in detail. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to everyone.

1. Start and stop the MySQL service

(Right-click to open the command prompt in administrator mode)

输入命令：net start mysql	来启动服务

输入命令：net stop mysql	来关闭服务

2. MySQL login and exit

2.0 MySQL parameters

输入命令参数：mysql -u root -p

Copy after login

命令行：mysql -uroot -proot --prompt -\h

prompt mysql>

SELECT VERSION();

SELECT NOW();

SELECT USER();

• [Keyword] and [Function] names are all in uppercase letters

• [Database] name , [Table] name, [Field] name all lowercase

• [SQL] statement must end with [;]

mysql tutorial》

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