SELECT * FROM `INNODB_COLUMNS`
|
TABLE_ID | NAME | POS | MTYPE | PRTYPE | LEN | HAS_DEFAULT | DEFAULT_VALUE | |
---|---|---|---|---|---|---|---|---|
1 | properties | 0 | 5 | 4130044 | 11 | 0 | NULL | |
2 | table_id | 0 | 6 | 1800 | 8 | 0 | NULL | |
2 | version | 1 | 6 | 1800 | 8 | 0 | NULL | |
2 | metadata | 2 | 5 | 4130300 | 10 | 0 | NULL | |
3 | database_name | 0 | 12 | 5439759 | 192 | 0 | NULL | |
3 | table_name | 1 | 12 | 5443855 | 597 | 0 | NULL | |
3 | last_update | 2 | 3 | 525575 | 4 | 0 | NULL | |
3 | n_rows | 3 | 6 | 1800 | 8 | 0 | NULL | |
3 | clustered_index_size | 4 | 6 | 1800 | 8 | 0 | NULL | |
3 | sum_of_other_index_sizes | 5 | 6 | 1800 | 8 | 0 | NULL | |
4 | database_name | 0 | 12 | 5439759 | 192 | 0 | NULL | |
4 | table_name | 1 | 12 | 5443855 | 597 | 0 | NULL | |
4 | index_name | 2 | 12 | 5439759 | 192 | 0 | NULL | |
4 | last_update | 3 | 3 | 525575 | 4 | 0 | NULL | |
4 | stat_name | 4 | 12 | 5439759 | 192 | 0 | NULL | |
4 | stat_value | 5 | 6 | 1800 | 8 | 0 | NULL | |
4 | sample_size | 6 | 6 | 1544 | 8 | 0 | NULL | |
4 | stat_description | 7 | 12 | 5443855 | 3072 | 0 | NULL | |
5 | id | 0 | 6 | 1800 | 8 | 0 | NULL | |
5 | thread_id | 1 | 6 | 1800 | 8 | 0 | NULL | |
5 | type | 2 | 6 | 1795 | 4 | 0 | NULL | |
5 | space_id | 3 | 6 | 1539 | 4 | 0 | NULL | |
5 | page_no | 4 | 6 | 1539 | 4 | 0 | NULL | |
5 | index_id | 5 | 6 | 1544 | 8 | 0 | NULL | |
5 | table_id | 6 | 6 | 1544 | 8 | 0 | NULL |
|