/*************************************************************************** * Navicat MySQL only 1000 record * Description: * Come in the morning, check the data in the database, the results navicat only see 1000 records, * View MySQL Database results are all the data, because Navicat can only display 1000 records. * 2016-10-29 Shenzhen Nanshan Ping Shan village Zengjianfeng ************************************************************* ************/First, reference documents:1The maximum number of records HTTPS can be inserted by the MySQL insert operation://zhidao.baidu.com/question/160402098.htmlSecond, view the actual data of the database: [[email protected]/usr/share/huishu]# mysql-h127.0.0.1-U Root-P Enter Password:welcome to the MySQL Monitor. Commands End With; or \g. Your MySQL Connection ID is 6481Server Version:5.1. the-Log Source Distribution Copyright (c) -, -, Oracle and/or its affiliates. All rights reserved. Oracle isA registered trademark of Oracle Corporation and/or its affiliates. Other names trademarks of their respective owners. Type'Help ;'Or'\h' forHelp. Type'\c'To clear the current input statement. MySQL>Use sensor; Database changed MySQL>Show tables; +------------------+ | Tables_in_sensor | +------------------+ | Baseinfo | +------------------+2Rowsinch Set(0.00sec) MySQL>SelectCOUNT (*) fromBaseinfo; +----------+ | COUNT (*) | +----------+ |6475| +----------+1Rowinch Set(0.00Sec
Navicat MySQL has only 1000 records