How to share auto_increment in two mysql tables?

Hello, I have a problem.
Ai need two tables to do different, that is what my id in the two tables were different.
Please help, for some reason Google refuses to help me today.
Maybe someone have thoughts about this?
I use mysql + php.
July 8th 19 at 15:59
3 answers
July 8th 19 at 16:01
Solution
Make one table even values, the other odd. dev.mysql.com/doc/refman/5.7/en/replication-option...
Thanks, somehow I had not guessed, made with php, even and odd, certainly not nice but as said a wise man.
Premature optimization is the root of all evil. - molly.Stanton commented on July 8th 19 at 16:04
: if done using PHP, see that was not a problem if there are two simultaneous inserts. - Violet_Wiso commented on July 8th 19 at 16:07
At the same time cannot be, in any case. - molly.Stanton commented on July 8th 19 at 16:10
July 8th 19 at 16:03
Copied part of your question without any changes put in search:
p27LvgycvgekA7.jpg
Found one of the possible options.
Another, if you know the maximum number of records, it is possible in one table to start with 0 increment, the other from the highest possible number

Bad Google! Since refuses to help you!

p.s. what for you is? There is something wrong.....
he in the course of andexer, there is this on the first page no - molly.Stanton commented on July 8th 19 at 16:06
July 8th 19 at 16:05
Make your counter for the ai. Put it in a separate table and adding the entry - id take that table and to that value +1 do.
I do not think that differently really to do it.

Find more questions by tags PHPMySQL