kurt.santo Posted January 29, 2008 Share Posted January 29, 2008 How do I alter details of a table structure? Have a table with a column date_added and one date_completed, both type TIMESTAMP . The problem I encountered: When the date_completed column is updated, it also updates the date_added. Therefore I would like to change the type TIMESTAMP TO DATETIME. How would I do this? I only know how to change records...Kurt Link to comment Share on other sites More sharing options...
justsomeguy Posted January 29, 2008 Share Posted January 29, 2008 How do I alter details of a table structure?With an ALTER TABLE statement. If you search online you should find plenty of references and examples. Link to comment Share on other sites More sharing options...
kurt.santo Posted January 29, 2008 Author Share Posted January 29, 2008 With an ALTER TABLE statement. If you search online you should find plenty of references and examples.Makes sense, will do some research on ALTER TABLE. Thank you.Kurt Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.