Leidago !Noabeb wrote:

> Hi
> I have the following tables setup in MYSQL:
> Region 1                                     Region 2
>                         HQ
> Tbl1 with autonumbered (PK)         Tbl1 with autonumbered (PK)
>     Tbl1 autonumbered-PK
> To explain the above. Basically there are two regions that collect
> information and then at the end of each month they have to send the
> information to HQ. This is fine, but the problem comes when the
> information (the data in the tables) is submitted to HQ. All three
> tables have the same names and the same structure. We want to
> synchronize the information sent by the regions into one table at HQ.
> How can we do this without having the duplicate number problem?

Typically you would do this by having a sufficiently large offset
between the numbers.  


Per Jessen, Zürich (19.6°C)

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to