一.select
显示当前日期和时间
-
mysql> select now();
-
+---------------------+
-
| now() |
-
+---------------------+
-
|2019-06-05 13:46:20|
-
+---------------------+
-
1 row in set(0.00 sec)
显示当前日期
-
mysql> select curdate();
-
+------------+
-
| curdate() |
-
+------------+
-
|2019-06-05|
-
+------------+
-
1 row in set(0.04 sec)
-
显示当前时间
-
mysql> select curtime();
-
+-----------+
-
| curtime() |
-
+-----------+
-
|13:48:15|
-
+-----------+
-
1 row in set(0.00 sec)
-
显示当前所在数据库
-
mysql> use test_db;
-
Reading table information for completion of table and column names
-
You can turn off this feature to get a quicker startup with -A
-
-
Database changed
-
mysql>select data base();
-
+------------+
-
| database() |
-
+------------+
-
| test_db |
-
+------------+
-
1 row in set(0.00 sec)
-
显示Mysql版本
-
mysql> select version();
-
+-----------+
-
| version() |
-
+-----------+
-
|5.7.16|
-
+-----------+
-
1 row in set(0.00 sec)
显示当前用户
-
mysql> select user();
-
+----------------+
-
| user() |
-
+----------------+
-
| root@localhost |
-
+----------------+
-
1 row in set(0.00 sec)
二.show
show variables;显示变量
show global variables;显示全局变量
show global variables like "%version%";显示版本信息
-
mysql> show global variables like "%version%";
-
+-------------------------+------------------------------+
-
| Variable_name | Value |
-
+-------------------------+------------------------------+
-
| innodb_version |5.7.16 |
-
| protocol_version |10 |
-
| slave_type_conversions | |
-
| tls_version | TLSv1, TLSv1.1 |
-
| version |5.7.16|
-
| version_comment |MySQL CommunityServer(GPL) |
-
| version_compile_machine | x86_64 |
-
| version_compile_os | Linux |
-
+-------------------------+------------------------------+
-
8 rows in set(0.00 sec)
show variables like "%storage_engine%";显示默认的存储引擎
-
mysql> show variables like"%storage_engine%";
-
+----------------------------------+--------+
-
| Variable_name | Value |
-
+----------------------------------+--------+
-
| default_storage_engine | InnoDB |
-
| default_tmp_storage_engine | InnoDB |
-
| disabled_storage_engines | |
-
| internal_tmp_disk_storage_engine | InnoDB |
-
+----------------------------------+--------+
-
4 rows in set(0.00 sec)
End.
作者：苦逼运维
来源：博客园
- 我的微信公众号
- 微信扫一扫
-
- 我的微信公众号
- 微信扫一扫
-
评论