ludders Posted October 6, 2005 Share Posted October 6, 2005 Hi, I know that not having an id field is really stupid but when I first made the table I was fairly inexperienced. I was making a 'review system' for my website. I have used it for nearly a year now but I am starting to have problems. I need to add a field for the id of each review but there is already over 100 reviews on my site. How do I add an ID field into my table and find values for all the reviews so far? I hope you can help, Ludders Quote Link to comment Share on other sites More sharing options...
effigy Posted October 6, 2005 Share Posted October 6, 2005 backup your database. after that my first guess is to use the alter table command then try 'update table set id=null'; that may auto increment them. Quote Link to comment 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.