Jump to content

Archived

This topic is now archived and is closed to further replies.

ludders

Add an ID Field

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.