In MySQL Workbench by default we will not be able to download or see all the records available in the table. We will be able to see only 1000 records and beyond 1000 is not possible to see but we might have scenario to see rest of the records as well.
There is settings in MySQL Workbench which prevents to see all the result-set records. We need to disable them like EDIT-->Preference -->SQL Editor-->SQL Execution.
Now unselect LimitRows if we do not want limitation to be applied or limit rows numbers can be increased in MySQL Workbench
There is settings in MySQL Workbench which prevents to see all the result-set records. We need to disable them like EDIT-->Preference -->SQL Editor-->SQL Execution.
Now unselect LimitRows if we do not want limitation to be applied or limit rows numbers can be increased in MySQL Workbench
0 Comments
Post a Comment