- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to check table status of the tables in a particular MySQL database?
We can check the status of tables in a database with the help of show table status statement. For example, in the database named tutorial, by executing this statement we can get the status of tables as follows −
mysql> show table status \G
*************************** 1. row *************************** Name: student Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 7340032 Auto_increment: NULL Create_time: 2017-10-24 09:34:29 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: 1 row in set (0.00 sec)
This database is having only one table named ‘student’.
- Related Articles
- How Can I check the size of the tables in a particular MySQL database?
- How can we check the character set of all the tables in a particular MySQL database?
- How to check statement of creating a particular MySQL database?
- How can I check MySQL tables from a database in accordance with particular column/s name?
- How can I check the character set of all the tables along with column names in a particular MySQL database?
- Get a list of non-empty tables in a particular MySQL database?
- How can we analyze the tables of a particular database from MySQL Server command line?
- How can we get the list of tables in a particular database from MySQL Server command line?
- How can we check the default character sets of a particular MySQL database?
- How to count the number of tables in a MySQL database?
- How to check an empty table already in a MySQL database?
- Check how many rows are in a MySQL database table?
- How to get the size of the tables of a MySQL database?
- How to alter the database engine of a MySQL database table?
- Create a stored procedure to get the detail of a particular MySQL table stored in a database?

Advertisements