MySQL Forums
Forum List  »  Knowledge Base

how to AUTO_INCREMENT table with data (fields) already existing
Posted by: Gwapo Kho
Date: December 11, 2008 05:53PM

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.


Options: ReplyQuote

Written By
how to AUTO_INCREMENT table with data (fields) already existing
December 11, 2008 05:53PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.