本篇Himi简单介绍一些MySQL数据库的基础操作;
注:mysql 语句对大小写不敏感,语句以分号“;”标识语句结束;
1. 首先使用两个简单的查询语句;
查询当前版本:select version();
查询当前日期:select current_date;
查询当前时间:select now();
两句合并: select version() , current_date , now();
显示结果如下:
mysql> select version() , current_date , now();
+-----------+--------------+---------------------+
| version() | current_date | now() |
+-----------+--------------+---------------------+
| 5.5.23 | 2012-04-17 | 2012-04-17 14:34:53 |
+-----------+--------------+---------------------+
1 row in set (0.00 sec)
2. SQL语句可分多行来写:
mysql> select version(),
-> current_date,
-> now(),
-> user();
+-----------+--------------+---------------------+----------------+
| version() | current_date | now() | user() |
+-----------+--------------+---------------------+----------------+
| 5.5.23 | 2012-04-17 | 2012-04-17 14:38:42 | root@localhost |
+-----------+--------------+---------------------+----------------+
1 row in set (0.00 sec)
3. 使用查询语句来作为计算器,让mysql 为我们计算结果,如下:
mysql> select 1*1,2*2,3*3;
+-----+-----+-----+
| 1*1 | 2*2 | 3*3 |
+-----+-----+-----+
| 1 | 4 | 9 |
+-----+-----+-----+