Hi All,

I'm using MySQL 4.0.16 on a W2K box and running MySQL as a service as well as the client.

Regarding the LIMIT keyword http://www.mysql.com/doc/en/SELECT.html says:

mysql> SELECT * FROM table LIMIT 95,-1; # Retrieve rows 96-last.

This does not work for me. I get:

ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 999, -1' at line 7

Without this LIMIT parameter my SELECT statement works, but I get only 1000 rows of output no matter what I do. I've tried raising my MAX_JOIN_SIZE but it does not have any effect. SHOW VARIABLES shows that it has not changed. However, I've also set a flag to ignore the JOIN limit. I've forgotten what that flag is called, but it seems to have worked, because I'm no longer getting the message that was telling me my SELECT would perform too many JOINs.

If there are more variables to set, how do I set them in my MY.CNF file so I never have to worry about this again?

I also can't use an embedded SELECT with an IN keyword that uses WHERE even though the embedded query works when I use it by itself.

Someone please try to help, even if you're not sure you know the answer. I am dead in the water because of this.

<soapbox on> So far this freeware is worth every penny I paid for it. I can see why, since MySQL's business model depends on you buying their support. I'm surprised they even support a user newsgroup. <soapbox off>

Gregg Roberts