As far as I know, MAX only returns the greatest row, so what you really
want at the end is
WHERE table_tmp.id=table2.id AND table2.timestamp=MAX(table2.timestamp)
~MJI
Roy Walker wrote:
Still having a problem with this. Still have one last thing that isn't working. This is MySQL 4.0.13.
UPDAT
I took once moe a sharp look now that you did a reply with another sample.
Actually I was wrong the SQL statement was NOT correct - you forgot the
semicolon in the first exapmple ;-)
To my knowledge, the semicolon is unnecessary when using mysql --execute.
~Michael Iatauro
--
MySQL General
Thanks for your reply, Nils.
and then I would like you to take a sharp look at whats left, then there
should perhaps be something with this part above. Perhaps the " at the very
end is not escaped correctly (double) or something similar. The actual SQL
statement works perfectly fine.
I thought
7;, 'Y', 'Y')\""
With the obvious changes to make the statement actually work. However,
if I move this over to Linux, I get Invalid Authorization Specification
errors when I try to connect as LocalUser after a reload, and using
GRANT seems never actually to grant p