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? Link to comment https://forums.phpfreaks.com/topic/249405-setting-up-a-database/ 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! Link to comment https://forums.phpfreaks.com/topic/249405-setting-up-a-database/#findComment-1280574 Share on other sites More sharing options...
mindapolis Posted October 19, 2011 Author Share Posted October 19, 2011 Good point Link to comment https://forums.phpfreaks.com/topic/249405-setting-up-a-database/#findComment-1280579 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.