MySql：插入具有相同唯一标识符的多行[关闭]

Question

I have a table for team partners:

id - Primary Key (auto inc)
first_name - text
last_name - text
team_number - number

I insert two records at the same time, and I want them to have a unique (if possible auto incrementing) team number.

At the moment, I do a count of the current table results, add 1 and insert that as a team number.

If I had 20 people entering data at the same time, I believe there's a risk of two teams getting the same team number.

Are my fears based in reality? If so, how do I mitigate that?

Answer 1

I think you do not mean that 'team_number' should be really unique, right?

So a team is based on two players, right? If so I would suggest to handle the logic in the program itself. Why you didn`t create a queue for that?

In that case you can insert 100 members at once but the queue should only get two at the same time and insert them before getting the next two members!?

Or do you need to handle this problem via SQL?