Benmcfc Posted May 26, 2009 Share Posted May 26, 2009 Hi all, I'm about to make major alterations to a few of my tables in order to create v2 of a certain service that depends on them. The issue is that there is already a lot of data in there from v1. For example, in v1 there is a varchar field in one of the tables containing the date and time, which is being replaced with timestamp. Elsewhere, there are some new columns, some columns being removed, etc. What I am wondering, is if I can maintain the old data whilst making these changes, or whether this is impossible? Obviously, I will be making a full backup of the db before starting to make the changes. Thanks in advance. Link to comment https://forums.phpfreaks.com/topic/159673-making-major-table-alterations-how-to-protect-data/ Share on other sites More sharing options...
JonnoTheDev Posted May 26, 2009 Share Posted May 26, 2009 No, a varchar will not convert into a date type. I would add the new date field and use a script to convert the varchar version and update the date field. Then you can remove the varchar field containing the dates. Link to comment https://forums.phpfreaks.com/topic/159673-making-major-table-alterations-how-to-protect-data/#findComment-842148 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.