"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 100000000 ?
Yes. See the previous post from Mike Blezien. What he didn't say is that
yes, you can have two identically structured tables with different
AUTO_INCREMENT values set at table creation time and then later insert the
records into a third table and retain the incremented values.
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/
---------------------------------------------------------------------
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