Jump to content

Alter table structure


kurt.santo
 Share

Recommended Posts

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...