数据库-mysql基础操作之输入查询

mysql-基础操作篇 

登录mysql 

mysql ‐uroot ‐p 
123456 

退出mysql 

mysql>quit 

输入查询 

查看当前mysql的版本号及当前时间 

SELECT VERSION(), CURRENT_DATE; 

mysql> SELECT VERSION(), CURRENT_DATE; 

+‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 
| VERSION() | CURRENT_DATE | 
+‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 
| 5.6.25 | 2018‐08‐08 | 
+‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 

mysql中sql语句不区分大小写

mysql> SELECT VERSION(), CURRENT_DATE; 
mysql> select version(), current_date; 
mysql> SeLeCt vErSiOn(), current_DATE; 
mysql> SELECT VERSION(), CURRENT_DATE; 
+‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 
| VERSION() | CURRENT_DATE | 
+‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 
| 5.6.25 | 2018‐08‐08 | 
+‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 
1 row in set (0.00 sec) 
mysql> select version(), current_date; 
+‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 
| version() | current_date | 
+‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 
| 5.6.25 | 2018‐08‐08 | 
+‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 
1 row in set (0.00 sec) 
mysql> SeLeCt vErSiOn(), current_DATE; 
+‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 
| vErSiOn() | current_DATE | 
+‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 
| 5.6.25 | 2018‐08‐08 | 
+‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 
1 row in set (0.00 sec) 

可以进行简单的计算（如下所示） 

mysql>SELECT SIN(PI()/4), (4+1)*5; 
mysql> SELECT SIN(PI()/4), (4+1)*5; 
+‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐+ 
| SIN(PI()/4) | (4+1)*5 | 
+‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐+ 
| 0.7071067811865475 | 25 | 
+‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐+ 
1 row in set (0.34 sec) 

多条语句比较短，可以写在一行

mysql>SELECT VERSION(); SELECT NOW(); 
mysql> SELECT VERSION(); SELECT NOW(); 
+‐‐‐‐‐‐‐‐‐‐‐+ 
| VERSION() | 
+‐‐‐‐‐‐‐‐‐‐‐+ 
| 5.6.25 | 
+‐‐‐‐‐‐‐‐‐‐‐+ 
1 row in set (0.00 sec) 
+‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 
| NOW() | 
+‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 
| 2018‐08‐08 23:11:11 | 
+‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 
1 row in set (0.00 sec) 

多个字段之间可以用逗号分隔，多行组成一条语句结束以分号结束 

mysql> SELECT 
‐> USER() 
‐> , 
‐> CURRENT_DATE; 
+‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 
| USER() | CURRENT_DATE | 
+‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 
| jon@localhost | 2010‐08‐06 | 
+‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐‐‐+ 

sql语句写了一半，又不想执行可以在语句末尾加上'\c' 

mysql> select 
‐> user() 
‐> \c 
mysql>