There might be some system that requires a 4 digit number and the PK is
being used directly. Also, this same system might need to be exported
to Excel, which trims leading zeros and is generally a pain in the ass.
Peter Westergaard wrote:
I've done exactly this for a really cheap-and-dirty ins
I've done exactly this for a really cheap-and-dirty instance where two
people were doing bulk data entry into two different instances of a mysql
table which would eventually be stitched together. by giving one a higher
range, the data migration afterwords was very easy.
Other than that, can't ima
I just had a bit of a play with it and discovered you can do this:
say your auto-increment index is named 'fred' for arguments sake.
INSERT INTO table SET FRED = 1000
This will just create a record where the auto-index fred will equal 1000.
Next auto-increment, NOT specifying a value for 'fred', wi
On Tuesday 13 July 2004 07:19, Michael Gale wrote:
> I know this is more of a mysql question then php with mysql but I can not
> find the answer.
www.mysql.com > search "auto increment" >
http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
Keep reading and re-reading that page until you
Michael Gale wrote:
I know this is more of a mysql question then php with
> mysql but I can not find the answer. I have a primary
> key in a table the is setup and working with auto increment.
Now I want to change it so it will start auto incrementing
> from 1000. So each entry will be:
First of
Hello,
I know this is more of a mysql question then php with mysql but I can not find
the answer. I have a primary key in a
table the is setup and working with auto increment.
Now I want to change it so it will start auto incrementing from 1000. So each entry
will be:
1001, then 1002,
I have approx 160 rows in a table with an ID column set to auto increment.
I have not changed anything suddenly one day the auto increment went from
162 to 2,145,694,203
I am running a Win 2000 box with IIS 5.
any ideas?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visi
