Using phpmyadmin I have created a new field in my table and I've called it id. I cannot autoincrement. When I try I get the following error:
ALTER TABLE users ADD id INT not null AUTO_INCREMENT FIRST
MySQL said: Incorrect table definition; there can be only one auto column and it must be defined as a key
Currently the table field email is primary and unique.
If I add a field id to my table, what sql statement can I write that would open each record and edit id such that I end up with a sequence of numbers for each record - 1, 2, 3, 4, 5, etc.