Read 172 times | Created 2014-11-13 17:46:38 | Updated 2014-11-13 17:46:38 | | |

 

USE 'database_name';
SHOW TABLE STATUS WHERE Name ='table_name';
-- ----------------

setara dengan:

-- -------------
SELECT 
table_name AS Name,
Engine,
Version,
Row_format,
table_rows AS Rows,
Avg_row_length,
Data_length,
Max_data_length,
Index_length,
Data_free,
Auto_increment,
Create_time,
Update_time,
Check_time,
table_collation AS Collation,
Checksum,
Create_options,
table_comment AS Comment 
FROM 
information_schema.tables
WHERE 
table_schema = 'database_name' 
AND 
table_name='table_name';