mysql workbench不显示下一个结果按钮

I have an issue with mysql workbench (under ubuntu), it doesn't show the next result button. my select * from my_table should return about 14000 rows but it displays only the first 1000 rows. Any idea ?

我有一个mysql workbench(在ubuntu下)的问题,它没有显示下一个结果按钮。我的select * from my_table应该返回大约14000行,但它只显示前1000行。任何的想法 ?

1 个解决方案

#1

Go through menu,

浏览菜单,

Edit > Preferences

Switch to SQL Queries tab,

切换到SQL查询选项卡,

Either uncheck the Limit Rows check box, or

取消选中Limit Rows复选框,或
Change the value of Limit rows count.

更改限制行数的值。

(Limiting the no. of rows in the result is not the proper way)

(限制结果中的行数不是正确的方法)

#1