Query to know particular table status in MySql
In Mysql, we can execute several queries. Here, i am going to demonstrate about important query. This query will show you the properties belongs to particular table.
Query :
SHOW TABLE STATUS LIKE TableName
The above query will return following coulmns,
Query :
SHOW TABLE STATUS LIKE TableName
The above query will return following coulmns,
- 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_option
- Comment
Good Commands..
ReplyDelete