MySQL Common statement Records

Table status Query (1) If you find that a data exception is large, you need to see which of these tables are larger, you can use the following command sql> SHOW table status from database name like data table name; or Sql>select table_name,data_length from Information_schema.tables; If the table is too small, use ALTER table to adjust: Sql>alter table Tbl_name max_rows=1000000000 avg_row_length=nnn; only tables with a BLOB or text column should be specified avg_   Row_length. (2) View the number of records in a table Sql>select count (*) from table;

MySQL Common statement Records