popmotsy Posted June 24, 2009 Share Posted June 24, 2009 hii to all, ??? ??? I want to make two fields AUTO Increment in the same table. Is that possible, is there any way to do this. Please if anyone know how to do this, please send me.. THANKS<<<waiting for reply<<< Quote Link to comment Share on other sites More sharing options...
MadTechie Posted June 24, 2009 Share Posted June 24, 2009 Why..the values would be the same.. so whats the point ? Quote Link to comment Share on other sites More sharing options...
popmotsy Posted June 24, 2009 Author Share Posted June 24, 2009 Hii MadTechie.. Ok well I explain the problam I hav 2 fields in table pod_id = 1338000 pod_no = 1338000 What I want to do is to insert another 1000 records incremmenting both the current field content so the result would be pod_id,pod_no 1338000,1338000 1338001,1338001 1338002,1338002 1338003,1338003 and so on. I am not sure which is the best way to do this. Quote Link to comment Share on other sites More sharing options...
MadTechie Posted June 24, 2009 Share Posted June 24, 2009 Why even have pod_no if its the same as pod_id ? Quote Link to comment Share on other sites More sharing options...
MadTechie Posted June 24, 2009 Share Posted June 24, 2009 To put is simply you can assign two fields the same auto_increment value in one query, you could create an update to update the pod_no to the same as the last id. but i still don't see why you would want this! 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.