i I have been using a database for months now with no problems. I was using my date as sort of my primary key. Now I wanted to use a plugin which requires I have a primary key which is not empty. I created one but gives me error because all the previous records have nothing in the newly created primary field. Is there a way to automatically fill all those records with serial numbers?(using auto enter serial number as my primary key) other than manually going through 1000's of records to repopulate them?
Please can anyone help?