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 -- Per Jessen, Zürich (19.6°C) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
