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

המאמר האחרון