in reply to Re: Need advice how to diagnose the problem when syntax using MAX() is correct according to MySQL monitor, but errors out in DBI
in thread [SOLVED] Need advice how to diagnose the problem when syntax using MAX() is correct according to MySQL monitor, but errors out in DBI

This represents years of experience of being shown everything but the actual problem code :). And lots of experience with misuse of ids, too. So often people want to use id to indicate temporal order and as hosed when it turns out a partial outage left some inserts out of order or when they want to add more historical data, I totally agree with afoken, wanting the max id usually means you're painting yourself into a corner.
  • Comment on Re^2: Need advice how to diagnose the problem when syntax using MAX() is correct according to MySQL monitor, but errors out in DBI