Re: ID numbers: auto-increment or sequences ?

2001-04-11 Thread Steve Werby
"Gunnar von Boehn" <[EMAIL PROTECTED]> wrote: > Can I somehow say that > in database (1) the autovalues should start with 1 > and in database (2) maybe with 1 ? Yes. See the previous post from Mike Blezien. What he didn't say is that yes, you can have two identically structured tables w

ID numbers: auto-increment or sequences ?

2001-04-11 Thread Gunnar von Boehn
Hi, 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? Wi

Re: ID numbers: auto-increment or sequences ?

2001-04-11 Thread MikeBlezien
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 = 1 >>For identification of each record in our database >>we use an 'autovalue'-column. >>It see