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.
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.
asked July 8th 19 at 15:59
3 answers
answered on
Solution
Make one table even values, the other odd. dev.mysql.com/doc/refman/5.7/en/replication-option...
answered on July 8th 19 at 16:03
Copied part of your question without any changes put in search:
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.....
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 commented on July 8th 19 at 16:06
answered on 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.
I do not think that differently really to do it.
Premature optimization is the root of all evil. - molly.Stanton commented on July 8th 19 at 16:04