NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.
All the Perl that's Practical to Extract and Report
--Larry Wall in perl.c from the perl source code
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.
Are you using InnoDB? (Score:1)
In which case I think you're stuffed since AFAIK this bug [mysql.com] is still open.
Add some triggers and doing it yourself would seem to be the obvious solution :-(
Re:Are you using InnoDB? (Score:2)
Can't use triggers with this version of MySQL (as I'm sure you're aware). However, even though the tables are MyISAM, the Update_time is not being set for me which is why 'SHOW STATUS' seems virtually useless.
(God I hate MySQL)
Reply to This
Parent