The mysql database, the actual insert data 1276, but in the list is not enough, the whole afternoon, later found early enough, who help explain, thank you!!!!!

CodePudding user response:

Don't have to struggle the building Lord, in the process of actual development use, the 997 can not get, get is the count value, if the original poster with this, try to change the client, the workbench

CodePudding user response:

Really work years haven't noticed this problem, the article seems to have always felt that the number is the same, then probably all guide go in early yesterday derivative according to the data, but look at the article 997, repeat again and again lead a afternoon, finally found the problem, but I don't know why, thank you very much for your reply!!!!!! thank you

CodePudding user response:

refer to the second floor goodlook0123 response:

does work years haven't noticed this problem, the article seems to have always felt that the number is the same, then the derivative according to may guide go in all the early data yesterday, but look at the article 997, repeat again and again lead a afternoon, finally found the problem, but I don't know why, thank you very much for your reply!!!!!! Thank you

The ROWS no, just a reference, I remember you to analysis table again, he will change, because it is random data records on part of the page, and then calculated the whole table how many records,

CodePudding user response:

Mysql common two types of engine: myisam and innodb
One of the difference:
Myisam article will record the table how many data, so the display is accurate
How many innodb does not record a table data, shown here is that the estimated

This feature to select count (*) from the performance of the table is almost the knowledge points of the interview will be asked

CodePudding user response:

The

reference 4 floor mingqing6364 reply:

mysql common two types of engine: myisam and innodb
One of the difference:
Myisam article will record the table how many data, so the display is accurate
How many innodb does not record a table data, shown here is that the estimated

This feature to select count (*) from the performance of the table is almost the knowledge point of the interview will ask

and learn new knowledge