Php Mysql Auto Increment Two Different Columns


I was wondering how I could auto increment two different columns in php mysql? For example I have the “id” column and have “count” column and I want to auto increment them at the same time. Is there a way for me to do that?



What are you trying to do? This sounds like a bad idea in the making.


I am trying to get the id upon inserting into table for my script but since it is not possible, I am trying to make an identical table to the ‘id’ so I can use it for the script.


But you can get the id on insert, how you get it just depends on if you are using mysqli or pdo.