0
Hello, my DB has several tables that have the same column:
`PROD` int(11) NOT NULL AUTO_INCREMENT
This column is an identifier that makes one that makes an increment with each launch. The issue is that it needs to receive the same value of the other tables, ie it needs to be unique as if this column was the same in all tables.
For example : If I make a release on Table 1 and this column shows the value 125 and after that make the release in table2 that value must be 126, ie it added with the value of the other table even without having received the release, because in my case she is only counting the releases in the table itself without taking into account the releases already made in other.
it seems to me a gambiarra... if you specify what would be Tabela1 and table2, maybe we can better understand what you need.
– Rovann Linhalis
Tabela1 for example would be of purchase and the table 2 of sale for example, if I make a launch in the purchase table the sales table will not receive anything, but would increase its increment by +1 for the two to have the same launch value as the PROD column.
– Wel