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?

Thanks

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.

https://www.w3schools.com/php/php_mysql_insert_lastid.asp

Sponsor our Newsletter | Privacy Policy | Terms of Service