how to AUTO_INCREMENT table with data (fields) already existing

[Gwapo Kho]

hello to each and everyone :)

the table i created has no define PRIMARY KEY, INCREMENT, UNIQUE, & Constraints.

i would like to ask our very-well knowledgeable Moderator(s) and to our guest to assist me again in my self-learning activities.

my table has already been created. in fact, it has now some data which i was able to refine its view or contents.

now, how can i make the column P_Id to be on its increment value ... what are the command(s) or syntax?

its like it has 10-data but only numbered from 1 to 8. i didn't put or included the number 9 and 10 when i inserted new data since i want it that if i add or change, i can do it in 1-single move (of course, by way of command line).

P_Id LName FName Address City zipcode Country


hoping to be guided accordingly.


cheers!