MySQL for WEB - Concurrency

[zeeshanhashmi]

Hi masters.

I want to ask that if we have a website and people REGISTERED themselves there. There is a Table for REGISTRATION, say MEMBER.

When a person registring him in the website and if the another person do it at the same time (as in the websites, millions of people visits the sites) then WILL IT BE A PROBLEM ? WILL I NEED TO HANDLE CONCURRENC ISSUE ? LIKE USING LOCKS ????? PLZ HELP

[guelphdad]

Use an auto increment column for an id number or something. Then it doesn't matter if the table is being accessed simultaneously, they won't both get assigned the same id number.

[zeeshanhashmi]

right, thanks .