EverKB

Knowledge Base Ever

MySQL, MariaDB, kako si ogledati sistem za shranjevanje tabele

2019-11-19 13:20:31

Oznaka: MySQL,MariaDB, Motor za shranjevanje, podrobnosti mize

Prva metoda

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)

Druga metoda

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)

Tretja metoda

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)

Oznaka

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