ClientID

[quadrant]

I want to change the ClientID to start at a higher number than 1. Is this possible? If so how can i change it?

 

Thanks

[othellotech]

simply read the mysql manual on auto-increment fields

[robb3369]

First verify your current highest client id:

SELECT max(id) FROM tblclients

 

Then use the following to set the next client id # (which MUST be higher than the above result + 1)...

ALTER TABLE tblclients AUTO_INCREMENT=xxx

[quadrant]

Thanks Guys!