Should be id as index or unique VARCHAR?

Databases
1

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.

2

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

1 Like
3

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

4

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.