View mysql Data Table Information

View the data table information. If you execute an SQL statement directly to the table, it may be slow when the table is large or other clients are operating on the table. For example, to view the number of records in the table, use: [SQL] SELECT COUNT (*) FROM tableName is very slow when updating a large table with other clients, it takes 3 or 4 minutes to return the result when you try to insert a table with 1 million rows and 20 clients. In fact, you can find the required data table information from the information_schema database of mysql. The database has a TABLES Table. Its main fields include: [SQL] TABLE_SCHEMA % database name TABLE_NAME % table name ENGINE % table ENGINE TABLES_ROWS % table record count DATA_LENGTH % data size INDEX_LENGTH % index size there are some other fields, for details, see the http://dev.mysql.com/doc/refman/5.1/zh/information-schema.html#tables-table on the official website to query this table to know the information of the data table. Author bhq2010