Navicat views the changing number of mysql Data Table records, navicatmysql

Navicat views the changing number of mysql Data Table records, navicatmysql

When using navicat for database management, you can view the table object and find that the number of records in the data table is constantly changing every time you refresh the table, especially for large tables.

For 1 million of the data, it is often displayed as, of course, the data obtained through count (*) is correct.

I was very confused. I checked the information and it was originally related to the storage engine. Official notes:

The number of rows. some storage engines, such as MyISAM, store the exact count. for other storage engines, such as InnoDB, this value is an approximation, and may vary from the actual value by as much as 40 to 50%. in such cases, use select count (*) to obtain an accurate count.
In an engine that does not support transactions such as myisam, this value is accurate and is estimated in an innodb engine that supports transactions.
Https://dev.mysql.com/doc/refman/5.1/en/show-table-status.html

I added 1500 pieces of information to a table in mysql, but I used Navicat for Mysql to view only 1000 pieces of information. I used cmd to see 1500 pieces of information.

Navicat for mysql. By default, the first 1000 entries are displayed in the table. Tool = option = Data & grid = Limit record. Here you can modify the default value. If you don't have this limit, you will be stuck there with ten million records ..

How to view Data Types in the table opened in navicat for mysql

The data list is displayed after the table is opened, and the field type cannot be viewed. To view the type of each field in the table, select the table and there is a "design table" on it. Click it to view the types of all fields.