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

##2.1 MySQL login

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

2.2 MySQL exit

Input parameters:

3. Modify the MySQL prompt

Method 1: Specify via parameters when connecting to the client

After we log in to MySQL, the original prompt should be [ >mysql], we change it to [localhost] through the following command

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

Method 2: After connecting to the client, modify it through the prompt command

prompt mysql>

At this time, the prompt will change to [mysql>]

4. Common commands

1. Display the version of the current server

SELECT VERSION();

2. Display the current date and time

SELECT NOW();

3. Display the current user

SELECT USER();

5. MySQL statement specifications

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

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

• [SQL] statement must end with [;]

Related recommendations: "

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!