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
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
fre 2002-12-27 klockan 22.34 skrev Martin Skjöldebrand:
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
On 27 Dec 2002, at 16:54, Fernando Grijalba wrote:
I believe it is
CREATE TABLE{
id AUTOINCREMENT=1000,
fld TYPE
}
Where did you see anything like that in the documentation?
I believe what Martin wants is something like
ALTER TABLE table_name AUTO_INCREMENT = 1000;
[Filter
At 22:34 +0100 12/27/02, Martin Skjöldebrand wrote:
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?
This question is ambiguous. Do you mean that you