EverKB

Knowledge Base Ever

MySQL, MariaDB com veure el motor d’emmagatzematge de la taula

2019-11-19 13:20:31

Etiqueta: MySQL,MariaDB, Motor d'emmagatzematge, detalls de la taula

Mètode primer

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)

Mètode dos

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)

Mètode tres

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)

Etiqueta

CentOS7 CentOS PHP Linux Python3 Python MySQL JavaScript MariaDB YUM Redis MySQL8 caching_sha2_password HTML mysql_native_password PHP7 CSS center Fatal Errors MongoDB4 sudoers .htaccess DATE_SUB Phalcon SQL Server 2017 WiFi Compiling PHP frequency conflict set_error_handler TestCase apr Elasticsearch7.3 PHPUnit ss5.conf 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 Apache2.4 Elasticsearch libpython3.7m.so.1.0 PHPStorm ss5-3.8.9 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 apache httpd dual network interfaces Laravel ss5 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 Apache du jQuery PHP5.5 src 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 ADDDATE DevExpress JetBrain php-fpm sqlsrv Zend Framework height network interface Shadowsocks-Libev unixODBC-devel Aura error_get_last Port 80 string data INDENTIFIED BY password policy requirements SOCKS Web Development Fedora Media Writer msodbcsql Redis5 SVN absolute Deepin jemalloc SQLAlchemy convert FuelPHP mysqlclient Shadowsocks toggle at-symbol Error Control Operator margin PHPUnit Framework ss5.passwd daemon process IIS password SOCKET vps