Am I posting to the right list? I'm new to this thing.
Anyway, I have an interesting, though I think not unusual predicament.. I'm
maintaining a number of different tables that contain timestamp fields that
keep track of the last time a record was modified. My problem is that if I
want to change any field specifications in one of these tables, that change
also activates and sets the timestamp field, which I don't want done. I
know how to get around this if I'm just doing an "update" query, but I can't
easily combine something like that with an "alter"...
This is what I have so far:
Create Table Backup (
id BigInt Unsigned Auto_Increment Primary Key,
modified TimeStamp,
);
INSERT INTO Backup (id, modified) SELECT id, modified FROM Items;
This should (provided I didn't typo anything) create a backup table full of
the modification dates. Once done, I can update the Items table any way I
need to. The problem is getting that data back INTO Items. I'm using Perl
for most of this, so I could rather easily write a routine to do it
manually, but I'm wondering if there's an sql statement that might handle it
easier (like a JOINed "update", which last time I checked couldn't be
done)..
Thanks,
Chris
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
