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.