使用select和show命令查看mysql数据库系统信息
2023-09-11 14:17:21 时间
(1).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 database(); +------------+ | 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)
(2).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 Community Server (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)
相关文章
- Mysql授权允许远程访问
- linux中mysql命令方式备份数据的问题
- 【MySQL】批量删除mysql中数据库中的表
- MySQL命令行导入导出数据库
- linux 中对 mysql 数据表的基本命令
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- mysql悲观锁总结和实践
- Ubuntu 安装mysql和 简单命令操作
- MYSQL错误解决:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- MySQL常见命令 [转]
- 查看MySql版本号命令
- MySql把手机号中间四位替换为星号
- 【问题解决方案】MySQL安装后无法启动-net start mysql服务名无效
- MYSQL避免全表扫描__如何查看sql查询是否用到索引(mysql)
- [转]2006 MySQL server has gone away错误,最大值溢出解决办法 mysql max_allowed_packet 查询和修改
- PHP面试题:你常用到的mysql命令?
- java+sql实现mysql数据表的数据结转
- csv批量导入mysql命令
- MySQL命令,一篇文章替你全部搞定
- 005-MYSQL数据库设计原则
- linux下关于mysql的命令的用法
- mysql_45 _ 自增id用完怎么办
- mysql_10 _ MySQL为什么有时候会选错索引?
- mysql 查看 脏页_MySQL:刷脏页
- 安装coreseek找不到mysql
- Mysql报错:Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- mysql--触发器复习
- mysql主从同步配置详解
- MySQL高级篇(SQL优化、索引优化、锁机制、主从复制)
- 【MySQL数据库原理】MySQL最有用的150条命令总结与案例使用