What primary keys are used for? I know that if I want to create index, I can use index keyword. I have keywords for creating unique and autoincrementing columns. It seems that I can do everithing what I need with other keywords. So can anybody explain why I need to use primary keys and in what situations?