dbutler Posted December 18, 2009 Report Share Posted December 18, 2009 I'm running an application based on PHP and MySQL (all hosted on same server). I've been requested to add some functionality to the application which would require me to add a column to an existing table. Here's my question: is there any danger in adding a new column to an existing table? The production table contains about 4000 records. I do know that the new column will not contain any data, just want to make sure I think all the way thru this before starting. Thanks! Link to comment Share on other sites More sharing options...
justsomeguy Posted December 18, 2009 Report Share Posted December 18, 2009 If you're worried you can back the table up first, otherwise just make sure the column either allows null values, or give it a default value. Link to comment Share on other sites More sharing options...
dbutler Posted December 18, 2009 Author Report Share Posted December 18, 2009 If you're worried you can back the table up first, otherwise just make sure the column either allows null values, or give it a default value.Cool, thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now