Re: Synchronizing autonumber fields
| From: | Per Jessen | Date: | Tue, 11 Aug 2009 07:43:49 +0000 |
| Subject: | Re: Synchronizing autonumber fields | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-296609@lists.php.net to get a copy of this message | ||
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)