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 Quote 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. Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/53775-solved-auto_increment-question/#findComment-265879 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.