dbutler Posted December 18, 2009 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 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 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
Archived
This topic is now archived and is closed to further replies.