DL,
Friday, January 18, 2002, 1:25:11 AM, you wrote:
DN KISS principle!
...
You can also examine the -A option of myisamchk.
-A, --set-auto-increment[=value]
Force auto_increment to start at this or higher value
If no value is given, then sets the
I believe auto_increment uses the last highest value inserted into the
record. So if your first insert is 1000, it will count up from 1000 there on
after. Correct me if wrong.
Mike
-Original Message-
From: Jure Grom [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 17, 2002 3:56 PM
To:
:[EMAIL PROTECTED]]
Sent: 17 January 2002 21:24
To: 'Jure Grom'
Cc: MySQL - List
Subject: RE: ID in table
I believe auto_increment uses the last highest value inserted into the
record. So if your first insert is 1000, it will count up from 1000 there on
after. Correct me if wrong.
Mike
Grom' [EMAIL PROTECTED]
Cc: MySQL - List [EMAIL PROTECTED]
Sent: 17 January 2002 22:43
Subject: RE: ID in table
It's messy but you can also insert x rows, then delete x rows and the next
row inserted will have id x+1 assuming that you started with 0 rows.
--
Peter Dunham