Should be id as index or unique VARCHAR?

I try to upload data feed inside MYSQL. As CSV file does not contain any id, how to manage id properties?

An example: should be as index Primary or I add unique value without an index?
If I understand index is an incremental value but we have a company values included people values from CRM which should be modified in the future.

please read this web site – Use The Index, Luke!

1 Like

Short answer - you should probably have a primary key.

There is some discussion about that here: https://stackoverflow.com/questions/840162/should-each-and-every-table-have-a-primary-key