AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
For the next time you opened the same table again, the limit record setting will be only based on the table view setting. In today's follow-up, we'll go through the process of creating a MySQL test database - all using Navicat 16. It can help produce a large volume of complex testing data over multiple related tables, all guided by a multi-step wizard. If the limit is reached, there will be a popup message which stops you from syncing until it is below the limit. It will only affect those tables / collections that you haven't set individual limit settings in the viewer.Īssumed you opened an existing table before. Recently, we learned how to generate test data using Navicat 16's new Data Generation tool. Is there a limit or maximum to how big my file can be updated at Ma22:12. Please be reminded that the Limit Records checkbox in Options, Preferences or Settings window is a global setting. Then, check the box Limit Records and fill it the numbers of records you would like to be displayed.įor macOS 8.x or above, please go to Navicat xxx > Preferences / Settings > Grids / Records tab, check the in the box Limit Records and fill it the numbers of records you would like to be displayed. For version 12 or above, please go to Tools > Options > Records. If you would like to make it as a global change to all tables / collections:įor Windows and Linux 11.2 or below, please go to Tools > Options > Appearance > Data & Grid. Click the icon once, then you are able to fill in the number you would like to limit. To set the limit of records / documents displayed per table / collection, you can find the icon at the right lower corner of the table / collection opened. How can I set the number of records / documents displayed per page in Table / Collection Viewer?Īpply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for MariaDB, Navicat for SQLite, Navicat for MongoDB, Navicat Premium
0 Comments
Read More
Leave a Reply. |