Re: ID in table

2002-01-19 Thread Victoria Reznichenko
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

Re: ID in table

2002-01-17 Thread DL Neil
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

RE: ID in table

2002-01-17 Thread Peter Dunham
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

RE: ID in table

2002-01-17 Thread Mike Grabski
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: