infinivert Posted May 31, 2007 Share Posted May 31, 2007 This is a stupid question, I know. But I'm honestly not sure how this works: I've got a table that has a secondary id field that will be used to link multiple records with different primary keys. I would like the secondary id to auto_increment, but I also need to override it occasionally so I can set several records to the same secondary id (this is how they will be linked). Make sense? So, can I set the field to auto_increment when I set the table up, and then manually enter values later? Nevermind. I can't have more than one auto-increment field, and it must be a key. My primary key already auto-increments, so I'll have to assign values in my PHP. Thanks anyway! --Josh Link to comment https://forums.phpfreaks.com/topic/53775-solved-auto_increment-question/ Share on other sites More sharing options...
fenway Posted May 31, 2007 Share Posted May 31, 2007 There is a multi-column auto-increment, but I doubt that is what you want. Link to comment https://forums.phpfreaks.com/topic/53775-solved-auto_increment-question/#findComment-265872 Share on other sites More sharing options...
infinivert Posted May 31, 2007 Author Share Posted May 31, 2007 No, but thanks for clue-ing me in! That will come in handy later... --Josh Link to comment https://forums.phpfreaks.com/topic/53775-solved-auto_increment-question/#findComment-265879 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.