Is there any Restriction

[Adrian]

I have a simple select statement on my table. But all my rows are not displayed. I want to know Is there any restriction on the number of rows getting displayed in MYSQL.

[cyrus]

Nice question. I know that there is restriction on the maximum number of rows getting displayed in MYSQL.I think it is 450. There is definitely some option to increase this. BUt even I am waiting for someone to post answer to this.

[Ralph]

Yes there is surely restriction on the number of rows getting displayed in MYSQL. But I am not sure whether it is 1000 or 2000.Someone has to post about this.