mysql的一些简单命令

查看mysql的版本、当前日期、时间、当前用户：

1 mysql> select version(),current_date,now(),user();
输出：
2 +---------------------+--------------+---------------------+----------------+
3 | version()           | current_date | now()               | user()         |
4 +---------------------+--------------+---------------------+----------------+
5 | 5.0.45-community-nt | 2015-09-17   | 2015-09-17 14:31:33 | root@localhost |
6 +---------------------+--------------+---------------------+----------------+
7 1 row in set (0.00 sec)

 查看mysql的数据库名称：

 1 mysql> show databases;
输出：
 2 +--------------------+
 3 | Database           |
 4 +--------------------+
 5 | information_schema |
 6 | mysql              |
 7 | sunshine_blog      |
 8 | test               |
 9 +--------------------+
10 4 rows in set (0.01 sec)

//创建数据库：create database sunshine_blog;

 

mysql当计算器使用：

1 mysql> select sqrt(25)*10,(8+9)*7;
2 +-------------+---------+
3 | sqrt(25)*10 | (8+9)*7 |
4 +-------------+---------+
5 |          50 |     119 |
6 +-------------+---------+
7 1 row in set (0.00 sec)

 

posted @ 2015-09-17 14:28  sunshine-habit  阅读(137)  评论(0)    收藏  举报