Synchronizing autonumber fields

From: Date: Tue, 11 Aug 2009 07:04:52 +0000
Subject: Synchronizing autonumber fields
Groups: php.general 
Request: Send a blank email to php-general+get-296608@lists.php.net to get a copy of this message
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? Thanks

« previous php.general (#296608) next »