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? 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)) 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 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
Archived
This topic is now archived and is closed to further replies.