In the last episode (Nov 17), Matt Babineau said: > Has anyone run into problems with this sql syntax? > > LIMIT -1 > > I've used this extensively in my code to get back all records rather then > specifing a limit. I've done this programmatically with PHP, so all my > queries have a limit even if I don't need one, I just have it specify LIMIT > -1, but apparently this functionality doesn't seem to work in 4.1???
>From http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html : # LIMIT no longer accepts negative arguments. Use some large number (maximum 18446744073709551615) instead of -1. not sure why it was changed, though. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]