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 increments each launch. The question is that it takes the same value from the other tables, ie it needs to be unique as if this column were the same in all tables.
For example : If I make a post in table1 and that column has the value 125 and after that post in table2 this value should be 126, that is, it added with the value of the other table even without having received the launch, because in my case it is counting only the postings in the table itself without taking into account the postings already made in others.