Remove limit on MYSQL results
I'm sure there's a setting somewhere where I can do this, but how can I remove the 1000 record limit for results returned from the database console. I'd like to see all the results in one screen rather than 1000 at a time.
Any hints where this is found in preferences or some other configuration menu?
请先登录再写评论。
Please try altering the "database.result.set.limit" value in Registry (Help > Find action > "Registry"), does it work?
Interesting that value is currently set at 100 but I'm seeing 1000 results. Seems like this may not be what I'm looking for, but I can give it a shot.
Hi there,
Settings/Preferences| Tools | Database | Data Views | Limit page size to
Works for DB consoles here (2020.2.3)