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!
