sebastiaandraaisma Posted January 27, 2007 Share Posted January 27, 2007 Hi, I have a question.Is it safe to create (add) a new column to an excisting table? I would want to add it at the end (far right) of the table and was wondering if it could give conflicts with excisting quiries in the website, if they somehow need to be updated or if I can just go ahead without any problems?Thanks in advance!Kind regards,Sebas. Quote Link to comment https://forums.phpfreaks.com/topic/35906-solved-can-i-safely-add-a-new-column-to-excisting-table/ Share on other sites More sharing options...
artacus Posted January 27, 2007 Share Posted January 27, 2007 It could cause problems. Like inserting records into this table if you have insert statements that don't have the fields listed you'll get an error saying column count does not match. It should be ok though. YOu can always try it and delete it if it messes up the application. Quote Link to comment https://forums.phpfreaks.com/topic/35906-solved-can-i-safely-add-a-new-column-to-excisting-table/#findComment-170324 Share on other sites More sharing options...
sebastiaandraaisma Posted January 27, 2007 Author Share Posted January 27, 2007 Thank you, that's a good advise.I will give it a try ;)Kind regards,Sebas. Quote Link to comment https://forums.phpfreaks.com/topic/35906-solved-can-i-safely-add-a-new-column-to-excisting-table/#findComment-170362 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.