Information_schema database structure of MySQL

1: key_column_usage table Constraint _Schema: Database Name Table _Schema: Database Name Table_name: stores database table information. Column_name: stores the field information of the database. Generally, you can obtain the information of the first or auto-increment field. 2: schema table Schema_ Name: name of the database to store Default_charater_set_name: storage charset type Default_collation_name: stores charset Information 3: schema_privileges table Grantee: database username Table _Schema: Table Name Privilege_type: Permission 4: statistics table Table _Schema: Database Name Table_name: name of the table to store Index _Schema: Database Name Index_name: Do you want to scale down? Column_name: stores the index auto-increment field? 5: tables Table Table _Schema: Database Name Table_name: name of the table to store Table_type: system or base table Engin: Memory MyISAM InnoDB Version: Table_rows: number of rows in the table Auto_increment: Total number of auto-increment rows Create_time: the time when the table was created. Update_time: the time when the table is updated. Create_options: Constraints for creating a table