Fyorl Posted September 26, 2003 Share Posted September 26, 2003 Is it possible to add a column to a table you\'ve already created? I\'ve got quite a big table with all the player stats on and I while I was creating it I forgot to add a hp column. Is there any way I can do this without, changing the name of the table and creating a new one? Because I don\'t want to then search through all my code, changing every instance where the old table name appeared. Also, if I add a column, will rows get added to it? Quote Link to comment https://forums.phpfreaks.com/topic/1067-adding-a-column-to-an-existing-table/ Share on other sites More sharing options...
shivabharat Posted September 26, 2003 Share Posted September 26, 2003 Try this ALTER TABLE <table_name> add column (hp varchar(100)) Quote Link to comment https://forums.phpfreaks.com/topic/1067-adding-a-column-to-an-existing-table/#findComment-3622 Share on other sites More sharing options...
Fyorl Posted September 26, 2003 Author Share Posted September 26, 2003 danke Quote Link to comment https://forums.phpfreaks.com/topic/1067-adding-a-column-to-an-existing-table/#findComment-3624 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.