Learn MySQL common operation command _ MySQL

1. start the MySQL server. In fact, the previous article describes how to start MySQL. Two methods: one is to use winmysqladmin. if the machine runs automatically at startup, you can directly go to the next step. Second, run d: mysqlbinmysqld2 in DOS mode, enter the mysql interactive operation interface, and run: d: mysqlbinmysql in DOS Mode. the following prompt appears: mysql. 1. start the MySQL server
　　
In fact, the previous article describes how to start MySQL. Two methods: one is to use winmysqladmin. if the machine runs automatically at startup, you can directly go to the next step. Second, run d: mysqlbinmysqld in DOS mode.
　　
　　 2. enter the mysql interactive operation interface
　　
Run: d: mysqlbinmysql in DOS mode
　　
The prompt "mysql" appears. the interactive mysql operation mode is displayed.
　　
If "ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)" appears,
　　
It indicates that your MySQL instance has not been started yet.
　　
　　 3. exit the MySQL operation interface.
　　
Enter quit at the mysql> prompt to exit the interactive operation interface at any time:
　　
Mysql> quit
　　
Bye
　　
You can also use control-D to exit.
　　
　　 4. the First Command
　　
Mysql> select version (), current_date ();
　　
+ ---------------- + ----------------- +
　　
| Version () | current_date () |
　　
+ ---------------- + ----------------- +
　　
| 3.23.25a-debug | 2001-05-17 |
　　
+ ---------------- + ----------------- +
　　
1 row in set (0.01 sec)
　　
Mysql>
　　
This command requires the mysql server to tell you its version number and current date. Run the preceding command in different cases to check the result. The results show that the case sensitivity of the mysql command is consistent.
　　
Perform the following operations:
　　
Mysql> Select (20 + 5) * 4;
　　
Mysql> Select (20 + 5) * 4, sin (pi ()/3 );
　　
Mysql> Select (20 + 5) * 4 AS Result, sin (pi ()/3); (AS: specify the alias AS Result)
　　
　　 5. multi-line statements
　　
A command can be input in multiple lines until the semicolon ";" is displayed:
　　
Bordercolorlight = "black" bordercolordark = "# FFFFFF" align = "center">