I have limited database experience and am about to try a big project, my question being what's the advantage to using numbers for the index of records rather than just making user name the primary and unique so you can always find the record by the name?
Such as keep track of users:
Why not say select * where user='john' ?
What's the purpose to having
Or is there any advantage?