what about RENAME current_table temp_table CREATE TABLE current_table (identical create_definition to current_table except adding the datetime column type) select * from temp_table
....checking here DROP TABLE temp_table Regards, Dan > -----Original Message----- > From: Laszlo G. Szijarto [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 26 February 2002 4:14 p.m. > To: [EMAIL PROTECTED] > Subject: any way to do this with SQL ??? > > > Thank you in advance for your help. > > I have a table which has a timestamp column. Now, I want to add > a column of > type datetime and transfer the original timestamp (date or original > insertion) into the new datetime column (so as to preserve this > information > for all posterity in case an new update to a row should alter the > timestamp > column). I had not intended to do any updates on this table (I > know, my bad > ! , for lack of planning). But now I see a need to do so. Can I do this > using sql ? > > Thank you very much in advance, > Laszlo > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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