0

I have to create several hundred users using mysql. How do I know which user IDs to give them? I don't want to duplicate already-in-use IDs, so is there a way to check which IDs are safe to use for new users?

Improve this question

1 Answer 1

Reset to default
2

You don’t give them IDs. The user ID column in the database is an ‘auto increment’ column, meaning that the value is automatically created whenever a row is added. So just add your users without an ID and the database will create one for you.

Improve this answer
2
  • I thought we were going to test this last Monday but there are delays, haha anyway, you are saying to just leave the ID col blank for each of the new users?
    – brothman01
    Jun 20, 2019 at 0:36
  • Yes, that's right.
    – Jacob Peattie
    Jun 20, 2019 at 0:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.