dqblm40280 2016-10-20 02:07
浏览 220
已采纳

MySQL中Select语句的默认上限是多少？

In MySQL workbench, SELECT statements have a 1000-result limit by default. Will that still be the case if I run a similar query from PHP? Does MySQL have a maximum number of rows that a SELECT statement can retrieve and, if so, what is it?

  • 写回答

1条回答 默认 最新

  • duanguane1670 2016-10-20 02:10
    关注

    There is no upper limit.

    In fact, you can just leave limit out of the query and return all the results, if you want.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题？