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<<< Link to comment https://forums.phpfreaks.com/topic/163481-autoincrement-2-fields/ 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 ? Link to comment https://forums.phpfreaks.com/topic/163481-autoincrement-2-fields/#findComment-862565 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. Link to comment https://forums.phpfreaks.com/topic/163481-autoincrement-2-fields/#findComment-862570 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 ? Link to comment https://forums.phpfreaks.com/topic/163481-autoincrement-2-fields/#findComment-862575 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! Link to comment https://forums.phpfreaks.com/topic/163481-autoincrement-2-fields/#findComment-862577 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.