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

Reply via email to