On Wed, 11 Apr 2001 14:42:47 +0200, Gunnar von Boehn <[EMAIL PROTECTED]> wrote:
with MySQL 3.23+ you can now assign the auto_increment start value, when
creating the table:
AUTO_INCREMENT = 100000000
>>For identification of each record in our database
>>we use an 'autovalue'-column.
>>It seems that this was a rather bad idea.
>>As we are now planning to run two individual databases.
>>In both of them records shall be written.
>>Later we plan to merge them together again.
>>
>>But how can we do this?
>>
>>With the 'autovalue'-ids we may end with record having the same ids.
>>
>>Can I somehow say that
>>in database (1) the autovalues should start with 1
>>and in database (2) maybe with 100000000 ?
Mike(mickalo)Blezien
========================================
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=========================================
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
