admin管理员组

文章数量:1426637

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?

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?

Share Improve this question asked Jun 16, 2019 at 2:40 brothman01brothman01 1941 silver badge11 bronze badges
Add a comment  | 

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.

本文标签: mysqlcreate new users in db starting at what ID