show table status;
(Redirected from Show table status)
Jump to navigation
Jump to search
show table status; ERROR 1046 (3D000): No database selected
show table status;
+-----------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------------------------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +-----------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------------------------------+---------+ | actor | InnoDB | 10 | Compact | 21 | 780 | 16384 | 0 | 32768 | 0 | 25 | 2020-05-10 12:47:36 | NULL | NULL | binary | NULL | | | | archive | InnoDB | 10 | Compact | 32 | 512 | 16384 | 0 | 65536 | 0 | 36 | 2020-05-10 12:47:36 | NULL | NULL | binary | NULL | | | | bot_passwords | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-05-10 12:47:36 | NULL | NULL | binary | NULL | | | | category | InnoDB | 10 | Compact | 524 | 93 | 49152 | 0 | 32768 | 0 | 629 | 2020-05-10 12:47:36 | NULL | NULL | binary | NULL | | | .../...
See also[edit]
- MariaDB:
mariadbcheck,mariabackup,mysqldump, MyRocks,show (MariaDB)MariaDB Changelog,50-server.cnf, MariaDB engines, .ibd, .myd, .myi,/var/log/mysql/error.log, MariaDB files:.frm,.ibd,/etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries,show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306
Advertising:
