I believe it is
CREATE TABLE{
id AUTOINCREMENT=1000,
fld TYPE
}
HTH
JFernando
** sql **
-----Original Message-----
From: Martin Skj�ldebrand [mailto:[EMAIL PROTECTED]]
Sent: December 27, 2002 16:34
To: MySQL epostlista
Subject: start value in table
Sorry for this newbie question (my MySQL-book is at work).
I want my ID field to start with value 1000 and (preferably)
auto-increment to 2000 is this possible to specify in my table somehow?
(I know auto-increment, just how do I set the starting value).
What would the appropriate SQL-sentence to update the table be?
Cheers,
Martin S.
--
Martin Skjoldebrand
http://www.skjoldebrand.org
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
