MySQL简单查询及规则

查询版本号和当前日期

mysql>  SELECT VERSION(), CURRENT_DATE;

+-----------+--------------+
| VERSION() | CURRENT_DATE |
+-----------+--------------+
| 5.1.73    | 2014-04-23   |
+-----------+--------------+
1 row in set (0.00 sec)

以大小写输入关键词（输入查询语句的时候不区分字母大小写）
mysql> SELECT VERSION(), CURRENT_DATE;
+-----------+--------------+
| VERSION() | CURRENT_DATE |
+-----------+--------------+
| 5.1.73    | 2014-04-23   |
+-----------+--------------+
1 row in set (0.00 sec)


mysql>  select version(), current_date;
+-----------+--------------+
| version() | current_date |
+-----------+--------------+
| 5.1.73    | 2014-04-23   |
+-----------+--------------+
1 row in set (0.00 sec)


mysql> SeLeCt vErSiOn(), current_DATE;
+-----------+--------------+
| vErSiOn() | current_DATE |
+-----------+--------------+
| 5.1.73    | 2014-04-23   |
+-----------+--------------+
1 row in set (0.00 sec)

mysql 用作一个简单的计算器
mysql> SELECT SIN(PI()/4), (4+1)*5;
+-------------------+---------+
| SIN(PI()/4)       | (4+1)*5 |
+-------------------+---------+
| 0.707106781186547 |      25 |
+-------------------+---------+
1 row in set (0.00 sec)

相当短的单行语句。你可以在一行上输入多条语句，只需要以一个分号间隔开各语句
mysql> SELECT VERSION(); SELECT NOW();
+-----------+
| VERSION() |
+-----------+
| 5.1.73    |
+-----------+
1 row in set (0.00 sec)


+---------------------+
| NOW()               |
+---------------------+
| 2014-04-23 15:56:05 |
+---------------------+
1 row in set (0.00 sec)

简单的多行语句的例子
mysql> select
    -> user()
    -> ,
    -> current_date;
+----------------+--------------+
| user()         | current_date |
+----------------+--------------+
| root@localhost | 2014-04-23   |
+----------------+--------------+
1 row in set (0.00 sec)

如果你决定不想执行正在输入过程中的一个命令，输入 \c 取消它
mysql> select
    -> user()
    -> \c
mysql> ;
ERROR: 
No query specified

输入一个分号完成语句， mysql 将执行

mysql> SELECT USER()

mysql>;

+----------------+
| USER()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)


mysql> SELECT * FROM my_table WHERE name = 'Smith AND age < 30;
    '> ;
    '>