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
To: "Mike Grabski" <[EMAIL PROTECTED]>; "'Jure 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 dele
ailto:[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
: MySQL - List
Subject: ID in table
Is there any way to start Ids in table from some number for exampl 1
with function auto_increment and not from 1?
tnx
jure
-
Before posting, please check:
http://www.mysql.com
> Is there any way to start Ids in table from some number for exampl 1
> with function auto_increment and not from 1?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch6_4_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Is there any way to start Ids in table from some number for exampl 1
with function auto_increment and not from 1?
tnx
jure
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
