mysql 删除 limit从MySQL Workbench删除limit子句,mysql删除数据库语句

I ' mrunningthisquery : select * from schema.table

buti ' monlygettingthefirst 1000 rows

iseeintheoutputwindowthattherewasalimitclauseappendedtomyselectstatement.isthereawaytoturnoffthedefaultlimit？

youcantogglethelimitclauseaddedbymysqlworkbenchviathesqleditortabwithintheapplicationpreferences，editmenu-preferences . )

简单检查限制行选项queryresultssectionaspicturedbelow。

EDIT:

In Workbench 6.0，the ' limit rows ' checkboxstandsin ' SQL queries ' tab (newtabofthesameform )。