EverKB

Knowledge Base Ever

MySQL,MariaDB如何查看表的存儲引擎

2019-11-19 13:20:31

標籤: MySQL,MariaDB, 存儲引擎,表詳細信息

方法一

MariaDB [erp]> show table status from erp where name='staff' \G
*************************** 1. row ***************************
            Name: staff
          Engine: InnoDB
         Version: 10
      Row_format: Dynamic
            Rows: 1
  Avg_row_length: 16384
     Data_length: 16384
 Max_data_length: 0
    Index_length: 0
       Data_free: 0
  Auto_increment: 2
     Create_time: 2019-11-19 12:34:33
     Update_time: 2019-11-19 12:34:33
      Check_time: NULL
       Collation: utf8_general_ci
        Checksum: NULL
  Create_options: 
         Comment: 
Max_index_length: 0
       Temporary: N
1 row in set (0.000 sec)

方法二

MariaDB [erp]> show create table staff;

| Table | Create Table
| staff | CREATE TABLE `staff` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `true_name` varchar(10) DEFAULT NULL,
  `login_name` varchar(20) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `can_use` tinyint(1) DEFAULT NULL,
  `is_leader` tinyint(1) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `login_count` int(11) DEFAULT NULL,
  `last_login_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 |

1 row in set (0.000 sec)

方法三

MariaDB [erp]> select * from information_schema.tables where table_schema='erp' and table_name='staff' \G
*************************** 1. row ***************************
   TABLE_CATALOG: def
    TABLE_SCHEMA: erp
      TABLE_NAME: staff
      TABLE_TYPE: BASE TABLE
          ENGINE: InnoDB
         VERSION: 10
      ROW_FORMAT: Dynamic
      TABLE_ROWS: 1
  AVG_ROW_LENGTH: 16384
     DATA_LENGTH: 16384
 MAX_DATA_LENGTH: 0
    INDEX_LENGTH: 0
       DATA_FREE: 0
  AUTO_INCREMENT: 2
     CREATE_TIME: 2019-11-19 12:34:33
     UPDATE_TIME: 2019-11-19 12:34:33
      CHECK_TIME: NULL
 TABLE_COLLATION: utf8_general_ci
        CHECKSUM: NULL
  CREATE_OPTIONS: 
   TABLE_COMMENT: 
MAX_INDEX_LENGTH: 0
       TEMPORARY: N
1 row in set (0.000 sec)

標籤

CentOS7 CentOS PHP Linux Python3 Python MySQL MariaDB YUM JavaScript mysql_native_password PHP7 CSS Redis MySQL8 caching_sha2_password HTML root Tag Cloud CodeIgniter font-size Laravel ss5 apache httpd dual network interfaces horiz-align node.js ShadowsocksR vertical-align CURLFille mb_substr PyCharm SUBDATE BarManager exec IntelliJIDEA PEAR SOCKS5 Proxy Server WebStorm date add remi Tag Chrome find jQuery PHP5.5 src Apache du hide nginx Shadowsocks-Python V2Ray cURL MariaDB10.4 PostgreSQL sub folder availability eth0 Install MongoDB pdo_sqlsrv SOCKS5 Web Server date mssql-tools register_shutdown_function Symfony File Upload JetBrain php-fpm sqlsrv Zend Framework ADDDATE DevExpress height network interface Shadowsocks-Libev unixODBC-devel Port 80 string Aura error_get_last INDENTIFIED BY password policy requirements SOCKS Web Development data msodbcsql Redis5 SVN Fedora Media Writer jemalloc SQLAlchemy absolute Deepin mysqlclient Shadowsocks toggle convert FuelPHP margin PHPUnit Framework ss5.passwd at-symbol Error Control Operator IIS password SOCKET vps daemon process MongoDB4 sudoers center Fatal Errors Phalcon SQL Server 2017 WiFi .htaccess DATE_SUB set_error_handler TestCase Compiling PHP frequency conflict PHPUnit ss5.conf apr Elasticsearch7.3 HTTP particles.js Slim Vincent Garreau daemon MongoDB Sudo Failed to build these modules: _uuid ip command pg_bha.conf SQL Server width DATE_ADD MySQL-python scrollbar Tcp BBR Compiling Apache Frameworks libpython3.7m.so.1.0 PHPStorm ss5-3.8.9 Apache2.4 Elasticsearch NodeJs show VIM CURLOPT_POSTFIELDS Minimal ISO substr Bluetooth Failed to build these modules: _ctypes INTERVAL PECL SQL Date Funcitons Wi-Fi date sub