chanveil Posted January 20, 2011 Share Posted January 20, 2011 I have a db that I want to add a customer number field to a table in a db. However, there are already many exixting customers to do one at a time. I want to create unique numbers for each one. An example would be 6516f6511r100000. Then, each one thereafter would increment by one. In addtion, each new entrant would auto-increment. Can anyone help with this? Thanks Link to comment Share on other sites More sharing options...
chokk Posted January 20, 2011 Share Posted January 20, 2011 In order for the database to auto-increment, the value of your id field must be an integer. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.