When creating a mysql table for local places whats the best primary key?
What would be the best primary key for a 开发者_如何学Cvenue in my area?
From performance point of view - a 4 byte integer, so a surrogate key. From some sort of a logical point of view, call it business logic - the name of the venue (natural key) assuming no 2 venues can share the same name.
精彩评论