mindapolis Posted October 19, 2011 Share Posted October 19, 2011 I'm setting up a customer database table. Could I use a compound primary key with the first name and last name or should I have an autoincrement field? Quote Link to comment Share on other sites More sharing options...
premiso Posted October 19, 2011 Share Posted October 19, 2011 Set the auto_increment field. Mainly because firstname and lastname are not always unique. Look at how many John Smith's there are in the world! Quote Link to comment Share on other sites More sharing options...
mindapolis Posted October 19, 2011 Author Share Posted October 19, 2011 Good point Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.