OriginalSunny Posted March 4, 2006 Share Posted March 4, 2006 Hi,I just need to know the command i require to change the column name of a table. The table is called 'products' the column is called 'pic' and the new name i want to change the column to is called 'prodpic'. Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/4075-command-to-change-column-name/ Share on other sites More sharing options...
SpectralDesign.Net Posted March 4, 2006 Share Posted March 4, 2006 [!--quoteo(post=351559:date=Mar 4 2006, 06:22 AM:name=OriginalSunny)--][div class=\'quotetop\']QUOTE(OriginalSunny @ Mar 4 2006, 06:22 AM) [snapback]351559[/snapback][/div][div class=\'quotemain\'][!--quotec--]Hi,I just need to know the command i require to change the column name of a table. The table is called 'products' the column is called 'pic' and the new name i want to change the column to is called 'prodpic'. Thanks.[/quote]Hey, I know the answer to this one!!!!ALTER TABLE `products` RENAME `prodpic` ; Quote Link to comment https://forums.phpfreaks.com/topic/4075-command-to-change-column-name/#findComment-14161 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.